Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have 2 Filters selected From and To
(e.g. From (Germany) and To (France) )
FROM TO Volume FROM-TO Volume TO-FROM
DE FR 2000
This shows me the volume we generated for this relation in a separate column
now I want to show the volume if the flow will go reversed (without changing the filters)
(This is how its been displayed right now for the "Volume From" column)
Now I need a similar measure to dispay into the opposite direction for the"Volume to" column
Any ideas how to display this?
@DHEG97 ,
Volume FROM-TO =
VAR FromC =
FILTER('Table', 'Table'[toCountry]=SELECTEDVALUE('Table'[ToCountry]))
RETURN
CALCULATE(SUM('Table'[Volume]),FromC)
or
Volume FROM-TO =
VAR FromC =
FILTER('Table', 'Table'[FromCountry]=SELECTEDVALUE('Table'[ToCountry]) && 'Table'[FromCountry]=SELECTEDVALUE('Table'[FromCountry]))
RETURN
CALCULATE(SUM('Table'[Volume]),FromC)
@amitchandak The first option will show me the volume from-to aswell in the new column
and the second option shows only blank entries
Where can I attach sample Data?
"The file type (.pbit) is not supported."
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |