Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct Count

Hi guys,   I'm having problems with a distinct count measure on card visualization on Power BI. Could you help me please?   I have a calculated measure on a matrix and I need to have a card to co...
Need Help
  • bpsearle's avatar
    bpsearle
    6 years ago

    Hi Pedro

     

    Start afresh and ignore the previous DAX measures for WOI < 2. Add 2 new measures:

    WOI < 2 (hidden) = if([WOI (8W)] > 0 && [WOI (8W)] < 2,1,0)

    WOI < 2 = SUMX ( VALUES ( SO_INV_LOJA[Nome da Loja] ), CALCULATE ( [WOI < 2 (hidden)] ) )

     

    For some reason I can't add a screen shot so will try doing that in another reply.

     

    The hidden measure calculates WOI but only in the context where you have the Nome da Loja. If you look at the total it shows as zero because the total WOIis 8.51.

    The visible WOI < 2 measure shows the total correctly because it is forcing the calculation to be applied at a grouped level.

     

    I found the answer here: https://brentgreenwood.blogspot.com/2012/12/dax-groupers-summarize-and-aggxvalues.html

     

    Thanks

    Brian

  • bpsearle's avatar
    bpsearle
    6 years ago

    screen shot:

Ross_PBI's avatar
Ross_PBI
Frequent Visitor
6 years ago

Anonymous  You have your greater than > and less than < symbols the wrong way round which is why v-juanli-msft  is confused. His interpretation of what the results should look like is correct based on how you present the <> symbols

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Ross_PBI  and v-juanli-msft , you guys are right. I switched the symbols.

 

Could you help me based on my answer to bpsearle ? I exemplified better what I am trying to do.

 

Thank u so much.

Pedro.