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:

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-juanli-msft  , thank u so much, I think that we are close now..

 

One more question. How can I calculate the SUM of Current INV considering that this field is a calculated one?

 

 

 

Thanks again,

Pedro.

bpsearle's avatar
bpsearle
Resolver II
6 years ago

Hi Pedro

You shouldn't need to wrap sum around the measure for the expression in calculate.

I'm going to have a quick look at mocking up the aggregate problem this morning and see if I can get an answer for that too!

Thanks,

Brian