I have below data and I have created simple table visualization in Power BI.
When the user clicks on any status in table 1, I want to find Percent total from the whole dataset which is 20 records.
i.e. User clicks on D result should display total records with Status D in that range/ total records in that range.
For 650 range there are 4 records and one record is with Status D, so 650 --- 25%(1/4)
What is the best way to achieve this?
|Range||Percent of D records|
Solved! Go to Solution.