Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi my fellow power BI users, I have been wracking my head for a solution to this PBI assignment, I am pretty new to the PBI so while I was able to handle power query and all, I wanted to figure out the DAX measures for this, as this is the requirement (create measures).
So, we were asked to unpivot some fact columns causing all the metrics to be in one column and all the values in the adjacent column. Then we were asked to make a summary table by grouping segment, manufacturer and brand and then aggregate the fact columns. I didn't know how to do that without including the metric column too so I added that too.
Here, you can see how the summary table looks like and I need to create seperate measures for each that:
For the sum, I was able to come up with something like:
@Anonymous , based on what I got. A measure like
Sumx(addcolumns(summarize('Appended Table', 'Appended Table'[segment], 'Appended Table'[manufacturer]) , "_mes" ,
Switch(True() ,
max(Table[Metric]) in {"A", "B"} , SUM('Appended Table'[Metrics]) ,
COUNT('Appended Table'[Metrics])
)), [_mes])
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |