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.
Good evening, I have 1 report that contains the balance for a list of projects. I want to simulate that one or several projects are zeroed, that is to say that the balance is multiplied by zero, only to some of the selected projects. I tried with SWITCH but it applies the zero to all the projects and not only to the selected ones. thanks for the help.
Solved! Go to Solution.
Hi @MikeKP72 ,
Try to use ALLSELECTED function
I create a seperate table to put [ID]. There's no relationship between two tables.
Table 2 = DISTINCT('Table'[ID])
Measure is like
Measure = IF(MAX('Table'[ID]) IN ALLSELECTED('Table 2'[ID]),0,SUM('Table'[Value]))
The [ID] in the slicer is from Table 2.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@amitchandak, Thanks for the tip, it helped me.
I still have to solve that selecting from that new table 2 or more projects does not work. The selectvalue is for single selections? Thanks
Hi @MikeKP72 ,
Try to use ALLSELECTED function
I create a seperate table to put [ID]. There's no relationship between two tables.
Table 2 = DISTINCT('Table'[ID])
Measure is like
Measure = IF(MAX('Table'[ID]) IN ALLSELECTED('Table 2'[ID]),0,SUM('Table'[Value]))
The [ID] in the slicer is from Table 2.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Stephen.
It helped me to solve the problem, and thanks for the example.
Regards
@MikeKP72 , for this you need an independent project table and you need to select a project from there
a mesure like. example
if(max(Table[project]) = selectedvalue(Project[Project]) , 0, sum(Table[Value])
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |