hierarchy on measure

[harshadsp]

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

[harshadsp]

Hello experts, any help on this, please?

Thanks

[harshadsp]

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!