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 all,
I created a measure to count based on a specific text value in a column.
This measure is showings the number of available monitors in my company by using this logic:
Solved! Go to Solution.
Hi @Anonymous ,
To make the external filters work, modify your DAX as follows:
The filter in your measure is overriding the filter from the Filter. To avoid that, you can add an IF before your expression.
CountAvailableAssets(FullList) =
IF (
"Yes"
IN VALUES ( 'Asset Management Full version'[Available] ),
CALCULATE (
DISTINCTCOUNT ( 'Asset Management Full version'[SBMBarcode] ),
'Asset Management Full version'[Available] = "Yes"
) + 0
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
The filter in your measure is overriding the filter from the Filter. To avoid that, you can add an IF before your expression.
CountAvailableAssets(FullList) =
IF (
"Yes"
IN VALUES ( 'Asset Management Full version'[Available] ),
CALCULATE (
DISTINCTCOUNT ( 'Asset Management Full version'[SBMBarcode] ),
'Asset Management Full version'[Available] = "Yes"
) + 0
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous ,
To make the external filters work, modify your DAX as follows:
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |