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

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

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      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

      • DavidB023's avatar
        DavidB023
        Helper III
        8 years ago

        v-juanli-msft

         

        It's perferct ! Thanks

        Best regards

        David