Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, could you please advise me how to perform below calculation?
I want to select particular value from "Grupa" table and show "Zmienna" in table on the left.
In below example it would be 0 for all rows and 1.11 for "Wyjazd".
Then I will perform multiplication of this "Zmienna" and value shown by measure in this table, but it should be easy if I overcome above issue.
Paweł
Solved! Go to Solution.
Hi @finch ,
Please follow steps below.
1. Create a table for slicer:
Grupa(for slicer) = VALUES('Table'[Grupa])
2. Add a what-if parameter:
3. Create a measure:
Measure = IF(MAX('Table'[Grupa])=SELECTEDVALUE('Grupa(for slicer)'[Grupa]),[Parameter Value],0)
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @finch ,
Please follow steps below.
1. Create a table for slicer:
Grupa(for slicer) = VALUES('Table'[Grupa])
2. Add a what-if parameter:
3. Create a measure:
Measure = IF(MAX('Table'[Grupa])=SELECTEDVALUE('Grupa(for slicer)'[Grupa]),[Parameter Value],0)
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@finch , based on the column name
if(selectedvalues([Grupa]) = max(Table[Grupa]), [Wyjazd measure], 0) +0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |