How to calculate record count

[MarshalSK]

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

Sample Data:

Country	City	State	Sales
United States	Houston	Texas	50
United States	Philadelphia	Pennsylvania	200
United States	Los Angeles	California	340
United States	Huntsville	Texas	100
United States	Huntsville	Texas	200
United States	Laredo	Texas	300
United States	Laredo	Texas	400
United States	Laredo	Texas	200

Expected Result:

[Ritaf1983]

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

[MarshalSK]

Hi @Ritaf1983 , DAX should work for below scenario as well.

[Ritaf1983 · Accepted solution]

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

[MarshalSK]

@Ritaf1983 Perfect Thanks

[Ritaf1983]

Happy to help😊