The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, I am trying to get the count of a column where the column value is equal to something. I have the below formula which works with 1 filter:
However, i want to filter on 3 options, i have tried the following but it doesnt appear to be working
Solved! Go to Solution.
@Anonymous , Try a measure like
CALCULATE(
DISTINCTCOUNT( 'enterprise-attack'[Value.x_mitre_platforms] ),
FILTER(
'enterprise-attack',[Value.x_mitre_platforms] in {"Windows","Linux","macOS"}
)
)
@Anonymous , Try a measure like
CALCULATE(
DISTINCTCOUNT( 'enterprise-attack'[Value.x_mitre_platforms] ),
FILTER(
'enterprise-attack',[Value.x_mitre_platforms] in {"Windows","Linux","macOS"}
)
)
Hello, thanks for that it doesnt appear to error anymore :). However, i only get an answer of 1 when ideally it should be 3?
ignore. Appears to be now working. Thank you