Forum Discussion

Habres's avatar
Habres
Regular Visitor
2 years ago
Solved

Subtracting two counts

Hi everyone! I have been trying for hours and searched for a solution, but I can't seem to get my dax code right. Maybe I not thinking in the right direction, because it does not seem so difficult...
Need Help
Habres's avatar
Habres
Regular Visitor
2 years ago

Hi tharunkumarRTK, thank for the reply!

This looks like a good workaround, but when I used this in my query it runs forever without giving output. So performance wise this is not working in my case.

Might there be another approach to calculate the result of COUNT_ID1 - COUNT_ID2 on the same DATE_ID?

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    Habres 

    I think there multiple ways to solve your requirement. You can create a seperate dim table with unique values of Date_ID1 and Date_ID2 and create a two relationships between the new table and your data table (one active and one inactive ralationship) and then write your count measures. You can use USERELATIONSHIP function when you want your measure to follow the inactive relationship.

     



    Need Power BI consultation, hire me on UpWork .


    If the post helps please give a thumbs up



    If it solves your issue, please accept it as the solution to help the other members find it more quickly.




    Tharun