Forum Discussion

betsysimpkins's avatar
betsysimpkins
Frequent Visitor
2 years ago

Secondary suppression using DAX

Hello all! I am having issues creating a single measure that will suppress all numbers < 10 and if there is only 1 number that is < 10, then I need to suppress the next smallest number regardless of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi betsysimpkins ,

Depending on the information you have provided, l created a sample data to help you with your problem, you can follow these steps below:

Sample data:

1.Create new measure.

 

Result = 
VAR _Number =
    SELECTEDVALUE ( 'Table'[NUMBER] )
VAR _Numberlessthan10 =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[NUMBER] ),
        FILTER ( 'Table', 'Table'[NUMBER] < 10 )
    )
VAR _Rank =
    RANKX ( ALL ( 'Table' ), CALCULATE ( MAX ( 'Table'[NUMBER] ) ),, ASC )
RETURN
    IF ( _Numberlessthan10 = 1 || _Rank <= 2, 0, _Number )

 

Final output:

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • betsysimpkins's avatar
    betsysimpkins
    Frequent Visitor
    2 years ago

    Thank you Ada! However, my problem is that in your example you have a table with a column for the number. My numbers are generated from a measure that does a headcount of studentID from the larger Enrollment table. So I think for your solution to work for me, I need to somehow create a table of the calculated values first right? I can't make SELECTEDVALUE work with a measure. 

  • betsysimpkins's avatar
    betsysimpkins
    Frequent Visitor
    2 years ago

    Thanks again for all your help...I've added a link here to some sample data from my Enrollment table. My measure to calculate the headcount of studentID is more complicated than needed for this sample data because of other filters I have to account for not shown in this dataset. But essentially it's just a distinct count of the studentID. Sample Data Extract for PBI