Forum Discussion

lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

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...
Need Help
  • lucadelicio's avatar
    lucadelicio
    3 years ago

    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!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Your 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)