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.
Dear All,
I can slice a table for the following row values: 0 1 2 3
What I want to achieve is a slicer where I can filter for the following options: 0 & 1, 0 & 2, 0 & 3.
In other words, you can slice for 1, 2 & 3 only but when you do you always slice for 0 as well.
Thank you very much
gianmarco
Is this what you are looking for?
total =
VAR _Valueselect =VALUES('Table'[Value])
VAR _SUM =CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value] in _Valueselect))
VAR _SUMSERO = CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value]=0))
VAR _Rsults = IF({0} in _Valueselect,_SUM,_SUM+_SUMSERO)
RETURN
_Rsults
Dear Ahmedx, not really.
Maybe it's less complicated than this.
Consider I want to filter a table by 4 clients: A, B, C & D.
When i filter for Client A, I want to obtain results as I would be filtering for A and D.
When i filter for Client B, I want to obtain results as I would be filtering for B and D
When i filter for Client C, I want to obtain results as I would be filtering for C and D.
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |