I’ve attached the pbix. I have the four slicers I’d like to use: 1) Fiscal Year, 2) Organization, 3) Project, 4) Project Type. @sam.mckay I had a couple questions, that I really thought would be easier. The measure below is saying. Calculate the standard deviation for FactInvoiceTable and the ALLEXCEPT means remove other filters except for ‘DimProject’[DimProj PROJECT_KEY] & DimProject’[DimProj PRIMARY_PROJECT_TYPE]?
stdev_proj_type_combo = CALCULATE(STDEV.P(FactInvoiceTable[TOTAL_INVOICE_PAID_AMOUNT]),ALLEXCEPT(DimProject,'DimProject'[DimProj PROJECT_KEY],'DimProject'[DimProj PRIMARY_PROJECT_TYPE]))
I originally created a measure for each individually, but I thought it was a little inefficient, so I wrote the above filter.
Also, I’m going to go through each total in the below table that is wrong and work through the IF HASONEFILTER exercise. Does that mean that each Measure that has a wrong total, I need to use a IF HASONEFILTER argument?forum_example_500.pbix (236.3 KB)