topic Re: How to fix this Slicer/Measure issue? Sample dataset provided in DAX Commands and Tips

How to fix this Slicer/Measure issue? Sample dataset provided

varelapablo90 — Mon, 11 Jul 2022 15:28:46 GMT

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 the different "entry source channels".

On the right side I have a slicer that I want to use it to filter the rawdata, therefore what I do not understand is why even though I filter for example "Manual" invoices I still see the values of ther other categories.

A shorter version of the example can be found in my PBI file.

https://drive.google.com/file/d/1Aoz_9C_CUt0aMk_iX18t0eZqMWuYq0fw/view?usp=sharing

Thanks a lot and looking forward for your help-.

Re: How to fix this Slicer/Measure issue? Sample dataset provided

johnt75 — Mon, 11 Jul 2022 16:15:59 GMT

The filter for manual is being applied to the whole table, so you are only seeing vendors who have at least 1 Manul entry. Within your measures you are explicitly filtering for just the appropriate entry type, so you are showing e.g. the number of ebilling invoices for those vendors who have at least 1 Manual entry.

The numbers your measures are showing are correct, you just need to understand the context.

Re: How to fix this Slicer/Measure issue? Sample dataset provided

varelapablo90 — Tue, 12 Jul 2022 08:24:46 GMT

If 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

Re: How to fix this Slicer/Measure issue? Sample dataset provided

johnt75 — Tue, 12 Jul 2022 08:54:37 GMT

You 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])))

Re: How to fix this Slicer/Measure issue? Sample dataset provided

Anonymous — Thu, 14 Jul 2022 06:17:26 GMT

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.