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.
Hi,
I have data as follows:
Cateogy in (A,L,I,B) comes under EAST segment, category in (K) comes under WEST segment, category in (N) comes under NORTH segment and category in (K,N) comes under CENTRAL segment (sum of WEST and NORTH segments), so I have written as follows:
I'm not getting the following when using above column
But I want to show as follows
Please help me to do.
Thanks,
AshDil.
Solved! Go to Solution.
Hi @AshDil ,
You can create the following by enter data:
Then use the following measure:
Measure = CALCULATE(SUM('Table'[Sales]),TREATAS(VALUES(Table2[Category]),'Table'[Category]))
For more details, please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @AshDil ,
You can create the following by enter data:
Then use the following measure:
Measure = CALCULATE(SUM('Table'[Sales]),TREATAS(VALUES(Table2[Category]),'Table'[Category]))
For more details, please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@AshDil , The last statement needs to be in {"K","N"}.
But that will also not work. Create a table with category and segment, in that case, you can repeat the category for the segment. Join new table on category and then you will be able to repeated values
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |