Forum Discussion
Distinct Count
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
screen shot:
Hard to say excalty what is needed with that limited information. Can you provide a sample of your data and what you'd expect the result to be?
Hi,
I can give you an example:
*WOI - Weeks of Inventory
store woi a 1.5 b 1.7 c 2.3 d 2.5 e 3 f 5 I need to create a conditional/dax on a card that shows me this:
WOI >2 WOI 2-4 WOI<2 2 3 1 How should I do this distinct counting considering that my WOI field is a calculated measure?
Thanks.,
Pedro.
Are those displayed results be what you would expect from the sample data you displayed?
I believe the expected results are shown below
WOI >2 WOI 2-4 WOI<2 4 3 2 Oh, sorry.. the right answer is: (like the colors)
store woi a 1.5 b 1.7 c 2.3 d 2.5 e 3 f 5 WOI >2 WOI 2-4 WOI<4 2 3 1 Im using this DAX, but the result is wrong:
teste = CALCULATE(DISTINCTCOUNT(SO_INV_LOJA[Nome da Loja]);FILTER(SO_INV_LOJA;[WOI (8W)]<2))