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.
In tableau I created a parameter and using the parameter created a calculated field using "case when" and used that field as measure to display it as value.
For Example:
Created parameter
Created measure:
and the result
I created the parameter but not able to use that parameter as measure. kindly help
@asdf1608 , You can use switch
You Can create a measure like
Sumx( Table,
Switch( selectedvalue(Param[Value]),
1, [Column1],
2, [Column2],
3, [Column3],
4, [Column4],
// add other
)
)
@amitchandak I created the parameter through fields which is not applicable for this scenario.
So I created the parameter from Power BI query. But only the first value is showing not the rest.
Can you guide me of how to create that display parameter?
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |