Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is my first post on literally any user group, so go easy on me 🙂
I am building a dashboard that calculates PV for a group of accounts. I'm attempting to leverage What-If parameters to allow the user to interact with the rate for that calculation, and because of that I am left writing the following measure:
Solved! Go to Solution.
Hi @redg ,
Please refer to the pbix file to see if it helps you.
Modify the measure.
gross_funding_am_sum =
VAR _b =
SUMMARIZE ( 'Sheet1', Sheet1[account_id], "aaa", [gross_funding_am] )
RETURN
IF ( ISINSCOPE ( Sheet1[account_id] ), [gross_funding_am], SUMX ( _b, [aaa] ) )
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @redg ,
Please refer to the pbix file to see if it helps you.
Modify the measure.
gross_funding_am_sum =
VAR _b =
SUMMARIZE ( 'Sheet1', Sheet1[account_id], "aaa", [gross_funding_am] )
RETURN
IF ( ISINSCOPE ( Sheet1[account_id] ), [gross_funding_am], SUMX ( _b, [aaa] ) )
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @redg ,
Please have a try
Create a measure.
Measure =
VAR _a = [gross]
VAR _b =
SUMMARIZE ( 'Table', 'Table'[Index.1], "aaa", _a )
RETURN
IF ( HASONEVALUE ( 'Table'[Index.1] ), _a, SUMX ( _b, [aaa] ) )
The gross measure stands for gross_funding_am. You can use the id column replace index.1 column.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-rongtiep-msft !
Thanks for taking the time to respond. I'm not sure that i'm understanding your solution and associated image properly. I think I'm not understanding something about your solution - I would expect the sum of the gross_funding_am field to be $17,883.33, not $23,452.20. I've also tried to implement your idea and i'm getting a sum of $32,980.99 (which further entrenches my belief that I'm not understanding what you mean). Can you elaborate a bit?
Thanks!
Hi @redg ,
It seems that the total value of measure is not correct, right? This document has a detailed explanation.
Please refer to.
There is also a post, please refer to it to see if it helps you.
How to remove duplicates count
If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (Or some sample data).
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @v-rongtiep-msft,
I'm attempting to share the PBIX file in a link here. Forgive me if this goes sideways... first time.
Hi,
In the total row, do ou want to add the figure appearing int the table visual above? Share the link from where i can download your PBI file.
Hi @Ashish_Mathur !
I would expect the total of the gross_funding_am column to equal 17,883.33 but that's not happening at the moment. I'm not entirely sure how to upload my pbix file here but as soon as I do I will follow-up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |