Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Team,
I was hoping if you could help me.
I have a scenario where i am calculating the Total Volume based on the following scenario.
1) IF one currency is selected than show currency Total value.
2) IF 2 or more currency is selected than show EUR Converted total value.
3) IF 43 or more currency is selected show total EUR converted value.
There is more paramaters that go inisde.
Problem here is that the the measure works for total. but when i add a filter on to the card to show either Buy or Sell it doesnt work how i predicted. Here is how is gets resulted.
As you can see works correctly where it only shows the buy Value but it ignores the first statement where if 2 currency are selected than it should show the EUR converted value: EUR 0.51MM and not PHP 215MM
Please could you see where i am going wrong?
Here are the measure used:
Solved! Go to Solution.
@ViralPatel212 , Try if this measure can help
Total Volume =
VAR _currencyCount = [currency count]
VAR _buy = CALCULATE([MV Size Actual EUR], 'glimpse-prod-db output_file_dtl'[side] = "Buy")
VAR _sell = CALCULATE([MV Size Actual EUR], 'glimpse-prod-db output_file_dtl'[side] = "Sell")
VAR _total = _buy + _sell
RETURN
IF (
_currencyCount >= 43,
_total,
IF (
HASONEVALUE('glimpse-prod-db output_file_dtl'[side]),
IF (
SELECTEDVALUE('glimpse-prod-db output_file_dtl'[side]) = "Buy",
_buy,
_sell
),
BLANK()
)
)
@ViralPatel212 , Try if this measure can help
Total Volume =
VAR _currencyCount = [currency count]
VAR _buy = CALCULATE([MV Size Actual EUR], 'glimpse-prod-db output_file_dtl'[side] = "Buy")
VAR _sell = CALCULATE([MV Size Actual EUR], 'glimpse-prod-db output_file_dtl'[side] = "Sell")
VAR _total = _buy + _sell
RETURN
IF (
_currencyCount >= 43,
_total,
IF (
HASONEVALUE('glimpse-prod-db output_file_dtl'[side]),
IF (
SELECTEDVALUE('glimpse-prod-db output_file_dtl'[side]) = "Buy",
_buy,
_sell
),
BLANK()
)
)
@amitchandak That did not work I tried the above in a measure and it returns a blank
Also i did add it to the main measure and it didnt work. (added it to the last if statement. not sure if its placed in the correct area) see below. the result returns the same as the card image above
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |