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.
Hi All,
What is the correct way to filter a column for 2 numbers?
I want to filter so that i get a total number of selection for 9 and 7
So far I have:
eROW = calculate([total respondents], OCE[Row] = "9,7")
wich obviously is not correct.
Then I thought it would be:
eROW = calculate([total respondents], OCE[Row] = "9" and "7")
but that's not right either
Solved! Go to Solution.
hi @e175429
try like:
Thank you @FreemanZ
The second option worked
hi @e175429
try like:
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |