Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community,
HASONEVALUE() not working on totals in matrix visuals. I'm getting blank value in matrix. I have a measure like below.
Solved! Go to Solution.
The totals should be blank if using HASONEVALUE, since there are multiple values in the Totals. If you want the SUM in the totals you can write something like this:
SUMX( VALUES( Tablen1[ID]), CALCULATE( IF( HASONEVALUE(Tablen1[ID]), IF( Sum([Amt]) = 0, 0, Sum([Sales])/Sum([Quantity]) ), "" ) ) )
The totals should be blank if using HASONEVALUE, since there are multiple values in the Totals. If you want the SUM in the totals you can write something like this:
SUMX( VALUES( Tablen1[ID]), CALCULATE( IF( HASONEVALUE(Tablen1[ID]), IF( Sum([Amt]) = 0, 0, Sum([Sales])/Sum([Quantity]) ), "" ) ) )
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |