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
You do not need a calculation. Insert a matrix visual onto the report canvas, add the AREA to Rows section and the CASE to Column selection then insert a CASE again to the Value section and set the aggregation to COUNT