Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

How to compute Brand by SOURCE ?

HI All   parry2k help me with the below post :-   https://community.powerbi.com/t5/Desktop/How-to-use-DAX-expression-to-count-number-of-brand-sales-gt-100K/td-p/2262931   Now i manage to comput...
Need Help
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

admin11  you can simply use this

Measure = CALCULATE(DISTINCTCOUNT(SALES_T[BRAND_C]),ALLEXCEPT(SALES_T,SALES_T[SOURCE]))