Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
How can I display only years where (not isempty([Measures].[Nombre de AN]) or not isempty([Measures].[Nombre de LEAD])?
I try this but how to apply OR?
Solved! Go to Solution.
You would need to create a measure or calculated column with someting similar to:
OR(
NOT (
ISEMPTY( [Nombre de AN] )
),
NOT (
ISEMPTY( [Nombre de LEAD] )
)
)
then filter on that, which will return TRUE or FALSE. You cannot create OR conditions for multiple measures/fields with the filter pane.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou would need to create a measure or calculated column with someting similar to:
OR(
NOT (
ISEMPTY( [Nombre de AN] )
),
NOT (
ISEMPTY( [Nombre de LEAD] )
)
)
then filter on that, which will return TRUE or FALSE. You cannot create OR conditions for multiple measures/fields with the filter pane.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCheck out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |