Forum Discussion
Count measures group by two different table without relationship
Hi everyone,
i need your help!
I have a STATUS table: Code (1, 2, 3) - Description.
I have a KRI table ID - Group - Description.
The two tables don't have any relationship.
I have n kri MEASURES that returns cod. of status (1, 2, 3).
Now i want a matrix that returns the number of KRI group by relative group (row) and status (column).
I wirte this measure that works by column but not by row. The total rows is wrong.
Some IDEAS?
Thank you! 🙂
I have created 4 different measure for different column for every status and the total.
In this way avoid the problem! Thak you at all!
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Your measure only works for the details rows. You should use HASONEVALUE('KRI'[ID]) to handle the summary row with a different measure formula.
Also, SUMX(x,1) is equivalent to COUNTROWS(x)
I have created 4 different measure for different column for every status and the total.
In this way avoid the problem! Thak you at all!
