Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
Hi,
I think this topic is in regards to a similar problem: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
Hi @SUNNY_ISLAND ,
Please have a try.
Based on the measure[Total value in SGD].
_contract_ =
var _b = SUMMARIZE('Date','Date'[Report curr],"aaa",'Data'[Total value in SGD])
return
IF(HASONEVALUE('Date'[Report curr]),'Data'[Total value in SGD],SUMX(_b,[aaa]))
Or you can use Other unique columns replace the column 'date'[Report curr].
If I have misunderstood your meaning, please provide a pbix file without privacy information and more details with your desired output.
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 @SUNNY_ISLAND ,
Please have a try.
Based on the measure[Total value in SGD].
_contract_ =
var _b = SUMMARIZE('Date','Date'[Report curr],"aaa",'Data'[Total value in SGD])
return
IF(HASONEVALUE('Date'[Report curr]),'Data'[Total value in SGD],SUMX(_b,[aaa]))
Or you can use Other unique columns replace the column 'date'[Report curr].
If I have misunderstood your meaning, please provide a pbix file without privacy information and more details with your desired output.
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,
I think this topic is in regards to a similar problem: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
@SUNNY_ISLAND
Please try the following version:
Total value in SGD =
VAR _CURRENCY =
MAX ( Data[Report curr] )
RETURN
SUMX (
data,
CALCULATE (
MAX ( 'Exch rate'[Exch rate] ),
'Exch rate'[Report Curr] = _CURRENCY
) * ( Data[Value] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for your suggestion but it is still not working. The end results remain the same. Would appreciate alternative suggestions. Much thanks
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |