Forum Discussion

kolturra's avatar
kolturra
Helper IV
5 years ago

First State with % Value

Hi,   i have table like this in which i want to reprsent first value of state name and concentnate with Total %   California 18.76%   Please note that Total % calculaation is comming from DAX o...
Need a help
kolturra's avatar
kolturra
Helper IV
5 years ago

Hi,

 

Thanks but we need max % value details in card. can you also please help with that DAX

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi kolturra 

 

Please create a column using following calculation

 

DIV = CALCULATE(DIVIDE(SELECTEDVALUE('Table'[Sales]),SELECTEDVALUE('Table'[REvenue])))
 
Secondly on your Card, pull "_fmt_str" (the measure created earlier) and then add DIV in the filter panel as shown in figure
 

 

This would give you desired output.

 

 

 

Thanks!