The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I need to convert this tableau measure to Power BI.
to use parameter and filter
How do I achieve this in Power BI.
Solved! Go to Solution.
see attached. Using measure as visual filter.
SWITCH ([Parameter1],
"Only open", CALCULATE(something,not [column1] = "Closed"),
"All", CALCULATE(something, [column1] in { "Closed","Open","------"})
)
There is nothing to calculate in that. I tried to use that field but it is not working.
I have attached a sample PBIX file.
Please help me in this.
Thanks in advance
User | Count |
---|---|
15 | |
13 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
9 | |
5 |