Forum Discussion
varelapablo90
Helper II
Helper IIHow to fix this Slicer/Measure issue? Sample dataset provided
Hello community I am having the bellow issue in a current report. I have a table with XWY Dimensions and as columns I am using some measures to calculate the amount of invocies received via t...
Hi varelapablo90 ,
Please refer to the pbix file to see if it helps you.
Modify the measures.
_EBILLING_INV = VAR _1= CALCULATE(sum(Table1[NrInvoices]), Table1[Entry_Source_Category] = "E-BILLING") RETURN IF(HASONEVALUE(Table1[Entry_Source_Category])&&MAX(Table1[Entry_Source_Category])= "E-BILLING",_1,BLANK())_FASTENTRY_INV = VAR _1= CALCULATE(sum(Table1[NrInvoices]),Table1[Entry_Source_Category] = "FAST ENTRY") RETURN IF(HASONEVALUE(Table1[Entry_Source_Category])&&MAX(Table1[Entry_Source_Category])="FAST ENTRY",_1,BLANK())_MANUAL_INV = var _a= CALCULATE(sum(Table1[NrInvoices]),Table1[Entry_Source_Category] = "MANUAL") return IF(HASONEVALUE(Table1[Entry_Source_SubCategory])&&MAX(Table1[Entry_Source_Category])="MANUAL",_a,BLANK())_OCR = VAR _1= CALCULATE(sum(Table1[NrInvoices]),Table1[Entry_Source_Category] = "OCR") RETURN IF(HASONEVALUE(Table1[Entry_Source_Category])&&MAX(Table1[Entry_Source_Category])="OCR",_1,BLANK())If I have misunderstood your meaning, provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
varelapablo90Helper II
Helper IIIf my whole dataset is being filtered by the slicer why would it show the figures from data that is not selected?
How can I make it work on the way I want?
By the way the raw data is on Invoice level
johnt75
Super User
Super UserYou would need to check within each measure whether there is a single value selected for the invoice type, and if it matches the relevant category, e.g.
E-Billing # = IF( SELECTEDVALUE(Table1[Entry_Source_Category]) = "E-BILLING", CALCULATE(SUM(Table1[NrInvoices])))