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,
using switch function
In follwoing scenarion ...
If(SELECTEDVALUE('ADMIN_step2_cost centers'[Group ])<>"Admin","ABC",0)
Total="ABC"
How to refer to Total column in the following scenario...
If(SELECTEDVALUE('ADMIN_step2_cost centers'[Group ])="Total","ABC",0)
to have
Total="ABC"
The "Total" is not included in ADMIN_step2_cost centers'[Group ], is Total of the matrix
thx for your reply!
Hey @Anonymous ,
you can check with the ISFILTERED function if there is a filter context for the column. If there is no filter it should be the total.
So try:
myMeasure =
IF(
NOT ( ISFILTERED( 'ADMIN_step2_cost centers'[Group ] ) ),
"ABC",
0
)
Unfortunately Total is treated as other columns.
As a result there are:
0 for NOT ISFIlTRED
ABC for ISFILTRED
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |