Im crushing my head with following issue in PBI.
I have data in column DTM which contains numeric and text values.
I need to count of DTM items which are in range 0 to 10, their Status is Open and its numeric value only (DTM column)
Results would look like - Count: 2
Any idea how DAX formula should look like?
Go to Solution.
You can create a measure like
Num Open =
VAR numVal =
IFERROR ( VALUE ( 'Table'[DTM] ), BLANK () )
numVal >= 0
&& numVal <= 10
&& 'Table'[Status] = "Open"
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.