I have two question.
i.) If number <=4 , return false . More than it will be true. I get the Dax. But I do not want the blank value in DiffDay return anything. But this DAX return false to the blank value.
Go to Solution.
@NickProp28 , I forgot My own suggested solution. Check now.
Proud to be a Super User!
View solution in original post
@NickProp28 , the formula seems fine. It is column check what value you have taken sum/min/max. Because on the color it will take aggregation.
You can also try a color measure and use that using "Field Value"
if it is a column
Color = IF(sum(SubBV[DiffDay])<=4, "Green", "Red")
It is measure Color = IF([DiffDay]<=4, "Green", "Red")
Dear @amitchandak ,
Thanks for ur prompt response. Yes, i able to get the correct colour after change from sum to min.
But do you have any idea on my another question? If Datediff less than or equal to 4 day will return false, while more than will be true.
And if datediff is blank, i do not want it to return anything. Just remain as blank.
But this DAX
@NickProp28 , for blank you can try like
Switch(true(),isblank(SubBV[DiffDay]), blank(),SubBV[DiffDay]<=4, "False"SubBV[DiffDay]>=5 ,"True"blank())
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Dear @amitchandak ,
I follow your code, but encounter error.
Here the pbix : https://ufile.io/sd52jjtxPlease take a look on the dataset.
Thanks for your help.
@NickProp28 , I think is happening because there multiple values job ID. so they adding up. I plotted it with unsummarized option and it worked
Please find the attached file after signature
In you pbix,
Datediff still fall into 'false' categories. I would want if datediff is blank, in the True/false column remain blank. Is it possible to do it? I tried many ways but still categories in 'false'.Appreciate your help.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.