Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
In the report which I am working, i had a requirement to show region with maximum and minimum data value. For maximum value, measure works fine but the minimum measure doesn't.
I have a matrix which has rows as Class(1st level) and Region(2nd level) and column as Type.
Current result:
Expected result:
Below is the dax measure used for finding min value,
var ranks = Rankx(all(region), datavalue measure ,,ASC,Dense) return switch(True(), ranks=2,datavalue measure)
The issue with this dax is when drilled down from Class -> Region, the total values doesn't show which means the values doesnt show for Class. I assume the change must be with "all(region)" statement in the dax measure.
Need some help on this.
Also, the categories, Class, Region and Type are from different dim tables which are connected to the fact tables via key column.
@AishwariyaV , Try like
var ranks = Rankx(all(region), datavalue measure ,,ASC,Dense)
return Sumx(values(region[region]) , switch(True(), ranks=2,datavalue measure))
@AishwariyaV ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |