Forum Discussion

MarshalSK's avatar
MarshalSK
Icon for Resolver I rankResolver I
2 years ago
Solved

How to calculate record count

Hi Folks, Need you assistance to count records in summarized table.

 

Sample Data:

 

CountryCityStateSales
United StatesHoustonTexas50
United StatesPhiladelphiaPennsylvania200
United StatesLos AngelesCalifornia340
United StatesHuntsvilleTexas100
United StatesHuntsvilleTexas200
United StatesLaredoTexas300
United StatesLaredoTexas400
United StatesLaredoTexas200

 

Expected Result:

 

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi MarshalSK 
    In this scenario you can create a calculated column :

    The updated pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

5 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi MarshalSK 
    You can use the basic countrows Dax function

    pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User
        2 years ago

        Hi MarshalSK 
        In this scenario you can create a calculated column :

        The updated pbix is attached

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly