• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

power bi dax measure with condition

Nicki

Member
Hi, please could you help me with the below measure,
My table : query 1
The column “Indicator” contains unique number like , 119
Mertric_Numerator is my calculated filed by choosing option from slicer
I want to get the result for Indicator number 119, then IF sum( numerator) is blank OR 0 or null “No Data” if
Sum(numerator) < 5 show “low count of data” else SUM(Query1[Metric_Numerator])
Many Thanks

MEASURE= IF(
SELECTEDVALUE(Query1[indicator])=119 &&
SUM(Query1[Metric_Numerator])<5, "Low count number",
IF( SELECTEDVALUE(Query1[indicator])=119 &&
SUM(Query1[Metric_Numerator])=0 ||ISBLANK(SUM(Query1[Metric_Numerator])), "No Data",
SUM(Query1[Metric_Numerator])
))
 
Top