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,
I'm using following measure to sum the InOut under the condition to filter the card visual only when I selected a stockmaterial and also replaced the typical blank when nothing is selected with "Please select stockmaterial":
Stockmaterial | Index | InOut | ||
a | i | 1000 | ||
aa | o | -1000 | ||
bb | i | 800 | ||
bb | o | -750 | ||
c | i | 32 | ||
d | i | 4234 | ||
d | i | 757 | ||
e | i | 234 | ||
e | i | 234 | ||
a | o | -683 | ||
a | o | -962 |
Solved! Go to Solution.
Download example PBIX file with the following code and visuals.
I'm not sure if you are asking to show 0 or BLANK() in trhe card visuals. Either way, it's easy to change.
Using these 3 measures
Sum InOut = IF ( ISFILTERED('DataTable'[Stockmaterial]), CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[Stockmaterial] = SELECTEDVALUE('DataTable'[Stockmaterial]))), "Please select stockmaterial")
Sum Ins = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "i" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0
Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0
Will give you the desired outputs in your cards
If you want the Sum In and Sum Out cards to show BLANK() rather than 0, remove the + 0 from the end fo each measure, e.g.
Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial])))
Regards
Phil
Proud to be a Super User!
"What I want to archieve is that when I select a stockmaterial with no outbound yet that the outbound cardvisual always show blank() instead of "0". "
You can try this measure
Measure =
var _value=CALCULATE(SUM('Table'[InOut]),FILTER(ALLEXCEPT('Table','Table'[Stockmaterial]),'Table'[InOut]<0))
return
IF(ISFILTERED('Table'[Stockmaterial]),IF(ISBLANK(_value),BLANK(),_value),"Please select stockmaterial")
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
"What I want to archieve is that when I select a stockmaterial with no outbound yet that the outbound cardvisual always show blank() instead of "0". "
You can try this measure
Measure =
var _value=CALCULATE(SUM('Table'[InOut]),FILTER(ALLEXCEPT('Table','Table'[Stockmaterial]),'Table'[InOut]<0))
return
IF(ISFILTERED('Table'[Stockmaterial]),IF(ISBLANK(_value),BLANK(),_value),"Please select stockmaterial")
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Download example PBIX file with the following code and visuals.
I'm not sure if you are asking to show 0 or BLANK() in trhe card visuals. Either way, it's easy to change.
Using these 3 measures
Sum InOut = IF ( ISFILTERED('DataTable'[Stockmaterial]), CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[Stockmaterial] = SELECTEDVALUE('DataTable'[Stockmaterial]))), "Please select stockmaterial")
Sum Ins = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "i" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0
Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial]))) + 0
Will give you the desired outputs in your cards
If you want the Sum In and Sum Out cards to show BLANK() rather than 0, remove the + 0 from the end fo each measure, e.g.
Sum Outs = CALCULATE(SUM('DataTable'[InOut]), FILTER(ALL('DataTable'), 'DataTable'[index] = "o" && 'DataTable'[Stockmaterial]= SELECTEDVALUE('DataTable'[Stockmaterial])))
Regards
Phil
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |