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.
I have a matrix
customer | Actual this year | Budget this year |
A | 100 | |
B | 100 | |
C |
I want A and B to be shown but not C
Is there a way to filter this
Normaly i would set filter for
"Actual this year" = not blank But that would filter out C and B
"Budget this eyar" = not blank But that would Filter out A and C
there is no way as i see it to make a combined filter ?
Solved! Go to Solution.
Create a calculated column using DAX or Edit Query.
Below is the DAX
required = IF(ISBLANK(MyTable[Actual this year])&&ISBLANK(MyTable[Budget this year]),"No","Yes")
Then apply filter.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandukrishnavs - yes that is what i have now .. or sort of...
has activity = ABS(MyTable[Actual this year])+ABS(MyTable[Budget])+ABS(MyTable[actual,LY]+ABS(MyTable[Budget, LY]))
and then a filter on that show if greater than 1
Create a calculated column using DAX or Edit Query.
Below is the DAX
required = IF(ISBLANK(MyTable[Actual this year])&&ISBLANK(MyTable[Budget this year]),"No","Yes")
Then apply filter.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandukrishnavs - yes that is what i have now .. or sort of...
has activity = ABS(MyTable[Actual this year])+ABS(MyTable[Budget])+ABS(MyTable[actual,LY]+ABS(MyTable[Budget, LY]))
and then a filter on that show if greater than 1
Ideally, C should not have come. Check have you check this option. Uncheck if checked
The problem is not that C is showing.... the probleing is having A and B stay.... either of the 2 filters will remove C but either of them will also remove to much
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |