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 All,
Is there any way that we can create hierarchy on measure in PBI desktop? I have a measure "Loss Ratio" on top and then need to add "Year" below that and at last "Business Line" below Year. So at top of hierarchy it would be a measure then I will further drill down to year and business line.
I serached over and found that measure could not be included in hierarchy but is there any way to achieve this type of functionality?
Please help!
Thanks
Hello experts, any help on this, please?
Thanks
I have calculated loss ratio as sum(table[claims])/sum(table[premium]) in "Loss Ratio" measure. The same formula won't work in column as it gives different results. Is ther eany way that the same results will be produced by column? If I could have such a column (which gives correct result as measure) then I could make a hierarchy on that column.
Please suggest, thanks!
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 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |