Forum Discussion

PoojaS5's avatar
PoojaS5
Frequent Visitor
3 years ago

Change value in table based on slicer which has two fields

Greetings,   Below is the table where i have some sort of transit time condition status, which has 4 consecutive columns contains region, mode, gross status and net status.(where i have 20K+ line i...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

PoojaS5 , better to unpivot columns Gross status, and Net status in the power query

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

 

Then you can have a measure

divide(countrows(filter(Table, table[Status]= "Met") ), countrows(Table) )