Count of a Measure

[dmyers1000]

Hello Everyone,

I am new to Power Bi, I created a measure that counts IDs per sales rep, however, what I am looking for is a secondary measure that will count the cels per day of that table that are less than 3 however it does not seem to count the zeros.

Any help would be appreciated!

Measure: 

CALCULATE(

DISTINCTCOUNT(vbpm_opportunity[Id]))+0

Table

The result I am trying to achieve is to count all red cels which are less than 3

2/2/2021	2/3/2021	2/4/2021	2/5/2021	2/6/2021	2/7/2021	2/8/2021
2	1	1	3	3	1	3

[parry2k]

@dmyers1000 sorry for the delay, I missed the attachment to get back on it. Cheers!

[parry2k · Accepted solution]

@dmyers1000 I missed pbix file, here it is :

CountX = SUMX ( SUMMARIZE( ALLSELECTED ( data[OwnerId] ), data[OwnerId],  "@Count", IF ( [CountID] < 3, 1, 0 ) ), [@Count] )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[dmyers1000]

@parry2k This solution works great!! thank you so much!

[v-xulin-mstf]

Hi @dmyers1000,

Try measure as:

Measure = 
CALCULATE(
    DISTINCTCOUNT(vbpm_opportunity[Id]),
    FILTER(
        Table,
        Table[cels]<3 && Table[cels]>0 && Table[Date]=MAX(Table[Date])
        )))

Best Regards,

Link

[dmyers1000]

Hi @v-xulin-mstf,

Thanks! however it does not seem to give me results, let me know if I am interpreting this wrong.

[parry2k]

@dmyers1000 It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

[dmyers1000]

Sure thing, below the link for pbix file, in the visual you will see an 2 tables, the table below (image) is the expected result which is counting the red cels from the table above. The issue is that I am not able to count zeros which are blanks.

PBIX FILE 

[parry2k]

@dmyers1000 try this

Count Less Than 3 = 
COUNTX ( VALUES ( Table[Date column] ), IF ( [Your Measure] < 3, 1 ) )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[dmyers1000]

Thanks however does not seem to solve the issue any other ideas?