Forum Discussion

Mariollo's avatar
Mariollo
Icon for Helper I rankHelper I
2 years ago
Solved

Toggle between absolute values and % - using field parameters

I have a table like below:     I would like to use field parameters to toggle between absolute and % values to have second view like below:   For first values I have simple D...
Need Help
Show and Tell
SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

Hi Mariollo 

You can remove the filter using the Calculate function

Absolute % =

COUNT ( Table[product_id] )

/

Calculate( COUNT ( Table[product_id] ), AllSelected(Table[range_column]))

 

 

Mariollo's avatar
Mariollo
Icon for Helper I rankHelper I
2 years ago

Thank you, this is also working 🙂