Powerbi

[Syedshah]

I am trying to make a DAX formula and I am not able to do it so I want your help.
I have a table named customer and column customer_number.

In customer_number some numbers fall under categroty A and some under B I want to make a new col for A so I can access customer_number of area A and get their sales report. 
How can I achieve this from DAX formula for Powerbi live connected .

[v-kkf-msft]

Hi @Syedshah ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @Syedshah ,

Assuming that the numbers 1, 2, 3, and 4 in the column belong to category A, then you can use the following measure as a visual-level filter.

Measure = COUNTROWS ( FILTER ( customer, customer[customer_number] in { 1, 2, 3, 4 } ) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.