Forum Discussion

shelleye's avatar
shelleye
Frequent Visitor
5 years ago

How to make a slicer modify a measure

Hello,    I am a beginner user of Power BI and I have a data table with trial balance data.  Each expense account has 2 grouping name columns.  The first grouping is the account description 1, i.e....
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, shelleye 

 

Try to create a measure like this:

Measure = 
var _Income=MAXX(FILTER(ALL('Table'),'Table'[Account Description 2]="Operating Income"),ABS('Table'[Amount]))
var _a=CALCULATE(ABS(SUM('Table'[Amount])),ALLSELECTED('Table'[Account Description 1]))
var _divide=DIVIDE(_a,_Income)
var _total=IF(ISFILTERED('Table'[Account Description 1]),_divide,1)
return _total

 Format the measure as Percentage

Result:

Please refer to the attachment below for details. Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.