Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello there, I am fairly new to dax and I still struggle with a lot of the simple concepts. I have been stuck on an issue for 4 days now and I need help. I ll try to describe my problem as good as I can...I hope it is easy solve.
I have a measure called [Average daily count] wich works fine and I need to display it in a matrice, but I want to filter it to remove unrelevent data.
here is my visual, I have highlighted the data to be removed
now I have managed to isolate the unwanted data using this measure on top of my [Average Daily Count Measure]
Here is the same matrice filtered with this new measure.
Then I thought, Ok too easy, replace = (equal to) by <> (is not ... if i am not mistaken)... and i should then filter this out of my matrix...
But it doesn't work
Here is the result, it just remove all the 8th hour row and all the sunday column
I tried for hours, read all I could, I can't figure out why and I just get more and more confused.
Could it be that I am using the wrong logical operator somewhere down the line ?
Any help would be greatly appraciated.
Solved! Go to Solution.
Just change the && to || in your expression, or you can try this approach instead
NewMeasure =
VAR result = [Average Daily Count]
RETURN
IF (
MIN ( Clock[Working Hour] ) = 8
&& MIN ( 'Date'[Day of Week Number] ) = 7,
BLANK (),
result
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Ginjko,
I think mahoneypat's suggestion should help.
In addition, you can also share some dummy data with raw table structure to help us clarify them and test to coding formula if these expressions do not work on your side.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Just change the && to || in your expression, or you can try this approach instead
NewMeasure =
VAR result = [Average Daily Count]
RETURN
IF (
MIN ( Clock[Working Hour] ) = 8
&& MIN ( 'Date'[Day of Week Number] ) = 7,
BLANK (),
result
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Still Cannot understand why yet but I replaced the && by || ... and It works like a treat.
Thanks a lot for your time and help.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |