Forum Discussion
Aggregate Revenues based on Gross Margin % using DAX/Data modeling
Hi everyone, This is my first question on PBI community. I am not new to using PBI but I need your help to get this visual right. The end result should look like the image. The measures are simpl...
Hi Anonymous,
I think you need to create a table with margin ranges(category, start, and end), then you can create a visual with margin category and write a measure to calculate based on the current margin category range limit.
If you confused about coding formula, please share some dummy data to test:
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng