topic Re: Numbers not coming in DAX Commands and Tips

Numbers not coming

souvik900766 — Sun, 31 Jan 2021 18:01:27 GMT

Hi !
My File :-https://www.dropbox.com/s/5fnohuk5yu88syz/switch%20problem.pbix?dl=0
My numbers are not showing after I am Filtering the slicer.
I want to calculate CTG of Brands (ON/ABOVE) Total Product and Rept NARTD available within Brand Name(brnd_nm) Column. (Refer the Data view)

Now, I want to use the ctgry_nm slicer to see the numbers either by Rept NARTD or Total Product in table 1.
In table 2 and 3 I have edited both the interaction and the numbers are coming.(The numbers are coming correct)

I tried with bookmarks but thats not acceptable by client !😑

Refer the picture !

Thanks in advance !

Re: Numbers not coming

Payeras_BI — Sun, 31 Jan 2021 22:19:07 GMT

Hi souvik900766 ,

Are all these filters on Brand name meant to be in this visual?

Once removed you get a number.

Re: Numbers not coming

souvik900766 — Mon, 01 Feb 2021 03:19:13 GMT

Hi Payeras_BI
Yes, they will be thr.Even Total Product and Reptd NARTD will not come. We will use Total Product and Rept NARTD jut to ca;lculate the CTG of Brands and view it with the ctgry_nm slicer.
My final View will be table 2 and 3 !

Re: Numbers not coming

Payeras_BI — Mon, 01 Feb 2021 08:38:47 GMT

Hi souvik900766 ,

In your data, you only have Brand Total Product for the Category Total Product and vice versa. The same happens for Reported NARTD.

Slicing by Category would exclude the rest of the brands.

I believe you want to switch between measures, not categories.

Something like this:

Find the pbix attached.

Let me know if that works for you.

Re: Numbers not coming

souvik900766 — Mon, 01 Feb 2021 09:04:45 GMT

Hi Payeras_BI ,
Yes you are right I want to switch between measures. That will also work and I am fine with it.
But i cant find the pbix file.

Re: Numbers not coming

Payeras_BI — Mon, 01 Feb 2021 10:54:15 GMT

Hi souvik900766,

Find it attached, mark my previous post as the solution if this helped you.

Re: Numbers not coming

souvik900766 — Mon, 01 Feb 2021 12:09:30 GMT

Payeras_BI Hi !
I have already tried this technique.
The problem is I have more visuals in the same page with different measures that is only working with the slicer with category from the main table.
Thats why I used this technique of two filters with bookmarks !

Re: Numbers not coming

Payeras_BI — Tue, 02 Feb 2021 12:32:38 GMT

Hi souvik900766 ,

A different approach that allows you to use the Category Name to switch between measures:

Re: Numbers not coming

souvik900766 — Wed, 03 Feb 2021 08:50:52 GMT

Hi Payeras_BI
It worked !!!!
Thanks !!!!