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.
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.