SELECTEDVALUE altered row persists in TOTAL of Matrix

[lync0056]

Hi All,

My Measure - 

Total Cashflow TEST = IF( SELECTEDVALUE(Accounts[Account Groupings]) = "Revenue", 0, [Total Cashflow])

On an individual row levelof Matrix, it correctly changes all Revenue Accounts to 0. But the GRAND TOTAL remains the same as if it included the Revenue. I.e. If I put both Total Cashflow and Total Cashflow TEST side by side, they both have the same GRAND TOTAL. Which is not the outcome I need. It should TOTAL and not inlude the Revenue items.

Help please

Thank you

[TomMartens · Accepted solution]

Hey @lync0056 ,

I have no idea what you try to achieve, but I'm surprised by the outcome you describe. As your measure takes the FALSE part for GRAND TOTAL both measures will return the value at the GRAND TOTAL line.

Please provide a pbix that contains some sample data, upload the pbix to onedrive or dropbox and share the link. Please describe the expected outcome.

Maybe you might consider to use SUMX and iterate across the accounts.

Regards,

Tom

[amitchandak]

Try

Total Cashflow TEST = calculate([Total Cashflow],Accounts[Account Groupings] = "Revenue")

Total Cashflow TEST = IF( isfiltered(Accounts[Account Groupings]) = "Revenue", 0, [Total Cashflow])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[lync0056]

@amitchandak  

Hi 

That will not work in this circumstance, as I am actually moving the result to different Account Type. See measure below. 

TESTING = IF( SELECTEDVALUE(Accounts[Account Groupings]) = "All Other Expenses",CALCULATE( [Total Cashflow MOVE Revenue], ALLSELECTED(Accounts)), 0)

This correctly puts the Revenue figure into the All Other Expenses row. It just does not include the figure in the Total of the Table at the bottom.

[v-chuncz-msft · Accepted solution]

@lync0056 

You may refer to the post below to add an additional measure.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

[TomMartens · Accepted solution]

Hey @lync0056 ,

I have no idea what you try to achieve, but I'm surprised by the outcome you describe. As your measure takes the FALSE part for GRAND TOTAL both measures will return the value at the GRAND TOTAL line.

Please provide a pbix that contains some sample data, upload the pbix to onedrive or dropbox and share the link. Please describe the expected outcome.

Maybe you might consider to use SUMX and iterate across the accounts.

Regards,

Tom