Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
Solved

Slicers

Hi everybody !   I have a slicer on my repport in order to display a value in euros, the rest to spend in euros and a purcentage of my rest to spend. So, I have many category but when I diselect...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi DavidB023

    After modifying the measure2 in my pbix provided as below

    Measure 2 =
IF (
    HASONEVALUE ( Table1[Category] ),
    [Measure],
    SUM ( Table1[Rest to spend] ) / SUM ( Table1[Budget] )
)

    I can show it on the visual when nothing is selected as follows.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago
How is your formula (“percentage of my rest to spend”) created?
How is the percentage reflected by selection of categories?
Could  you share me some data example?
 
 
Best Regards
Maggie
    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      8 years ago

      Hi DavidB023

      I can solve it but create measures instead of calculated columns.

       

      Here is my modified pbix.

       

      Best Regards

      Maggie

      • DavidB023's avatar
        DavidB023
        Helper III
        8 years ago

        v-juanli-msft


        Do you think it is possible to have when nothing is select, just the purcent of the total rest compared to total budget ?

         

        Thanks

        Best regards

        David