Power BI dax measure unique value filter and switch

[Nikko]

Hi,

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 the sum of numerator is blank “No Data” if

Sum of numerator is ?< 5 show “low count of data” else leave it blank ,    SUM(Query1[Metric_Numerator])

Please help

MEASURE= IF(

    SELECTEDVALUE(Query1[indicator])=119 && ----119 is unique id in indicator column from query1table

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])

    ))

[Anonymous]

Hi @Nikko ,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[ribisht17]

Please post some sample data here