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 the following measure.
I just want to exclude and "Others" values in the calculate measure.
How to do this...?
below is my current measure.
Dep-A |
Working |
Not Working |
Working |
Not Working |
Working |
Working |
Not Working |
Working |
Others |
Others |
Solved! Go to Solution.
Hi @saivina2920 ,
Step 1: Create a new measure
M_Dept-A 2 =
CALCULATE(
COUNT(DummyTable[Dept-A]),
KEEPFILTERS(
DummyTable[Dept-A] <> "" &&
DummyTable[Dept-A] <> "Others")
)
Step 2 : Visualize
Hope that helps
@saivina2920
Please try
Test =
CALCULATE(
COUNTROWS(Sheet1),
FILTER(ALL(Sheet1[Column1]),
Sheet1[Column1] <> ""),
Sheet1[Column1] <> "Others")
If this helps, please mark this as a solution
BR
Dax_noob
Sorry. it's not working...showing syntax error.
Hi @Anonymous ,
Thanks for your help,
i am trying to form donut chart using the above measure.
But, i don't want to show the "others" and blank in the donut chart.
How to remove the blank and "others" in the donut chart.
pls. find the below url for reference file.
Hi @Anonymous ,
Can you pls. correct the measure which is attached my file with this..
this is very important.
Hi @saivina2920 ,
Step 1: Create a new measure
M_Dept-A 2 =
CALCULATE(
COUNT(DummyTable[Dept-A]),
KEEPFILTERS(
DummyTable[Dept-A] <> "" &&
DummyTable[Dept-A] <> "Others")
)
Step 2 : Visualize
Hope that helps
Yes. It's perfect...Thanks...
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |