Forum Discussion

DavidB023's avatar
DavidB023
Icon for Helper III rankHelper 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
Icon for Community Support rankCommunity 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
Icon for Helper III rankHelper 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
    Icon for Community Support rankCommunity 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
      Icon for Helper III rankHelper III
      8 years ago

      v-juanli-msft

       

      It's perferct ! Thanks

      Best regards

      David