Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Simple IF measure

Just learning here and I searched the forum and well, was a bit overwhelmed by the multiple options for similar questions so thought I'd try my own. I can easily figure out how to add a column to do ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Greg, is it really that complicated? It's so exceeding easy to do this as a column. I trust you know what you're doing as I'm familiar with your book, so wondering if maybe I'm not asking the question the right way. It would seem to ,e that the temp table setup would only ever allow this to work if the aggregation was on company. What if it changed to account manager? 

that commission column I'll trying to calculate is something that needs to summarized by any other possible values in the pivot. 

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

is it really that complicated? 

First, you should know that:

1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result in a visual by its row context.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

Second, you could use this simple measure to get the result on it row context:

Measure = IF(SELECTEDVALUE('Table'[Commissionable]),SUM('Table'[Sales])*0.1)

But this will lead a measure problem, See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

and this post:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

Now you will need to create another new measure as below

m_Total 1 = 
VAR __table = SUMMARIZE('Table1',[Company],[Commissionable],"__value",[m_Single])
RETURN
SUMX(__table,[__value])

 

 

 

Regards,

Lin