Creating Measures (or DAX?) in Power Pivot

[gwoolley0302]

Hello,

I'm looking for some guidance with if and how I could use measures to help me create some enhanced pivot tables.

I have detailed a couple of specific questions in the document here (in red text in the Sheet: Pivot Test): s666-PQ-Impact system 2019.11.15a-ver4.xlsx

But to summarise I'm looking to:
1. summarise the results of 4 columns in one pivot into 2, whereby in the new table column 1 = column 1 of the of the original table, but column 2 of the new table should represent column 2,3 and 4 of the original table.
2. *apply an IF statement to selected specific rows for a summary calculation, for instance I think I might need to create a measure of some kind for the data in Sheet 6, such as: "=If(E5 + E8 + E11 + E14 > 0), "Yes", "No"). But that is one student and one parent category. I would want to repeat that calculation for every student and every parent category.

* But I think this may be easier to understand from looking at the spreadsheet.

Any help you can give would be really appreciated!

Greg

 

[nikio8]

you can write calculated columns in your data model. have you used "switch" for multiple if else ?
tricky part with measure is that you should create new measure for each column, that way you can reference them later, rather than referencing something like "sum of columnName"