Forum Discussion

singhranjeet101's avatar
singhranjeet101
Frequent Visitor
3 years ago
Solved

Count Values at the Firm Level not at office level

Hi Team, I have got a data set which includes three columns  Clients Name | Offices | Revenue I am looking to count the clients which have a revenue of more than 1M But when i try to count using th...
General Comment
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

singhranjeet101's avatar
singhranjeet101
Frequent Visitor
3 years ago

Thre you go

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • singhranjeet101's avatar
      singhranjeet101
      Frequent Visitor
      3 years ago

      Thanks a lot Ashish. It works

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        You are welcome.

    • singhranjeet101's avatar
      singhranjeet101
      Frequent Visitor
      3 years ago

      Hi Ashish, Following up on the same scenario. I also want to sum the name which has a revenue of greater than 1M. I am able to do it on a firm's level but when apply a office filter i get wrong sum of revenue by office.

      Below is the Dax im using.

       

      Clients Rev >1M =
      CALCULATE
          (
           SUM([Rev]),
          FILTER(
                  Values(
                       'Data'[Name]),
                                                               'Data'[Rev] >= 1000000  
           
              )
                   )
       
      I was wonderinf if you could help?
       
      Thanks