Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago
Solved

Numbers not coming

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 !

8 Replies

    • souvik900766's avatar
      souvik900766
      Icon for Helper IV rankHelper IV
      5 years ago

      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 !

  • Payeras_BI's avatar
    Payeras_BI
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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.