Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
My Measure -
Solved! Go to 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
You may refer to the post below to add an additional measure.
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
Hi
That will not work in this circumstance, as I am actually moving the result to different Account Type. See measure below.
You may refer to the post below to add an additional measure.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |