Forum Discussion
How to use countx with multiple parameter
HI Team i do have this below table Area Case Sydney Review Sydney Accepted Melbourne Dispute Melbourne Dispute Melbourne Review Perth Accepted Perth Review Sydney...
Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.Anonymous
Create two measures: I attached the file below my signature.Count = COUNTROWS(Table1)Count % = DIVIDE( [Count], CALCULATE( [Count], ALLSELECTED(Table1[Case] ) ) )
Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.
HI Fowmy, thanks for replying,
I am counting how many % complted every Area by case wise. like Sydney is having 4 rows then how many % for Review, Dispute....