Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Count based on revenue amount

I need 3 measure like >5, <5, result basically we need to create >5 how many distinct count of desc based on amount criteria, suggest example table: Desc Amount A 10 B 4 C 5 D ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Anonymous 

     

     

    Assuming Amount is a physical column in your table, the measure would be

    CALCULATE (
    DISTINCTCOUNT ( 'table'[desc] ),
    keepfilers ( 'table'[amount] ) <= 5
)

    But youre expected result is confusing thouugh. I thought you wanted the distinct count which means that each value in desc should only be counted once - C has 2. If you mean to say the count of records, use:

    CALCULATE (
    COUNTROWS ( 'table' ),
    keepfilers ( 'table'[amount] ) <= 5
)

    Just change <= to  > for a different calculation.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you danextian and ryan_mayu for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by ryan resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and give a kudos if you found it helpful.

 

Thanks and regards,

Anjan Kumar Chippa