Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.