Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |