Numbers not coming

[souvik900766]

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 !

[Payeras_BI · Accepted solution]

Hi @souvik900766 ,

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

[souvik900766]

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

[Payeras_BI]

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.

[souvik900766]

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.

[Payeras_BI]

Hi @souvik900766,

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

[souvik900766]

@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 !

[Payeras_BI]

Hi @souvik900766 ,

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

Once removed you get a number.

[souvik900766]

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 !