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 My Friends,
How Are You?
So I Have a Table Like this:
Travel ID | Motive | Value |
1 | A | 1000 |
2 | A | 2000 |
1 | B | 1000 |
1 | C | 2000 |
2 | B | 1000 |
3 | A | 3000 |
4 | A | 2000 |
4 | B | 1000 |
So, what i need is to take All Travels IDs wich has the same number and SUM it!
If the Sum's Value is between 0 and 1000 Show it as Low Cost
If the Sum's Value is Over 1001 Show it as High Cost
After that I Wanna count how many Low Cost, How Many High Cost Travels i have
Is it possible to do this without creating a New Table? Just creating a New Measure?
I Was trying to create a new measure, than summarize my table and finally do an "If", but i can not refer to my Variables Columns using "IF"
Awnser =
VAR MyVar = Summarize('Table'; 'Table'[Travel ID]; "TOTAL"; Sum('Table'[Travel ID]))
RETURN
If ( MyVar[TOTAL] < 1001 ; "Low Cost"; "High Cost)
Solved! Go to Solution.
Hi @Anonymous ,
First create a table with your ranges:
After create this measure:
Hi @Anonymous ,
First create a table with your ranges:
After create this measure:
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |