Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Simple count certain values within measure

Hello   I am looking to count certain values within a measure using DAX formulas.   Below is a list of the distinct count of users per day: Date                    Users 3/01/2022 A 4/01...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for the link.

    Could you please try the below for calculating "appeared once" ?

     

    Users count who have one in grand total measure 02: = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE ( Data02, Data02[Date], Data02[Name] ),
            "@count", CALCULATE ( SUMX ( Data02, 1 ) )
        ),
        [@count] = 1
    )
)

     

    Please also check the attached pbix file. 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pibx file.

 

 

Users count who have one in grand total measure: =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE ( Data, Data[Users] ),
            "@count", CALCULATE ( SUMX ( Data, 1 ) )
        ),
        [@count] = 1
    )
)