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

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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data and clearly show the expected result.