Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]) ), "" ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |