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.
I have a matrix table on the report page
I used this formula for A: IF([Measure 1]>=10,[Measure 1],BLANK())
And I used this one for B: IF([Measure 1]<10,[Measure 1],BLANK())
As you can see it works generally. Only values are displayed based on the IF function. However, unfortunately it also applies to the totals (bold numbers). In this particular case column A should be empty and the total of 13,63 should be displayed in column B.
How can I achieve this?
Hi @TimmK -
Try this type of pattern
MeasureA =
IF (
HASONEVALUE ( 'Table (2)'[Column1] ),
IF ( SUM ( 'Table (2)'[Column1] ) > 10, SUM ( 'Table (2)'[Column1] ), BLANK () ),
SUMX (
FILTER ( ALLSELECTED ( 'Table (2)' ), 'Table (2)'[Column1] > 10 ),
'Table (2)'[Column1]
)
)
MeasureB =
IF (
HASONEVALUE ( 'Table (2)'[Column1] ),
IF (
SUM ( 'Table (2)'[Column1] ) <= 10,
SUM ( 'Table (2)'[Column1] ),
BLANK ()
),
SUMX (
FILTER ( ALLSELECTED ( 'Table (2)' ), 'Table (2)'[Column1] <= 10 ),
'Table (2)'[Column1]
)
)
Hope this helps
David
Hm, not sure if this can work this way.
There are quite complex formulas behind the measures. First, I calculate the total work hours, then I calculate the target hours per day, and finally I substract the latter from the first.
Hi @TimmK - it depends on what is creating the "filter" on the table/matrix display. You haven't given much detail on the data or your model, or what the entire visual should look like (a table with nothing but measures is going to have one row). If you can provide more detail we might be able to help better.
See How-to-Get-Your-Question-Answered-Quickly for tips on what to share with your question.
David
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 |
---|---|
41 | |
26 | |
20 | |
13 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |