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.
Hello Everyone
I am new at POWER BI , and stuck in this issue for a while , I hope anyone could help me out
here it is my stucking part in a simple way among many other relationships and cauclations
I have a "volume" table ,
item | volume | source |
A | 1 | WEST |
A | 2 | EAST |
B | 3 | WEST |
B | 4 | EAST |
C | 5 | WEST |
C | 6 | EAST |
and a "filter" table
filter list |
A |
B |
C |
I want to sum the {volume} on the items exsited in filtered column {filter list}
I am using CALCULATE(SUM(volume[volume]),FILTER(volume,SEARCH(volume[Item]),VALUES(filter[filter list]),,0)>0))
this works ok when I only filtered one value , it goes error if I filtered "A" and "B" at the same time .
what is the correct formula should be used ?
I need to create a measure to caculate this , build relation between table will not help in my case
thanks
Eric
Solved! Go to Solution.
HI @erche3
How about this MEASURE
Measure = CALCULATE ( SUM ( Volume[volume] ), TREATAS ( VALUES ( 'Filter'[filter list] ), Volume[item] ) )
But If there is a relationship between tables,, a simple sum of Volumes should give you the answer as well
HI @erche3
How about this MEASURE
Measure = CALCULATE ( SUM ( Volume[volume] ), TREATAS ( VALUES ( 'Filter'[filter list] ), Volume[item] ) )
It works AMARZING!!!
thanks a lot . I know I could put relationship in this example ,but it real case ,I could not since I need to combine this outcome with other caculations
but this is definately what I am asking for !
thanks!!!
Since both the tables have common field.....they can be joined easily I believe
See file attached
But If there is a relationship between tables,, a simple sum of Volumes should give you the answer as well
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |