Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 Reporting