Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SUM unique values from filtered table

Hello, everyone! I am new in Power BI, and I haven't been able to start my dataviz because I'm stuck with the data transformation.    I have a data set that is essentially this.      I hav...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smpa01 this helps for this simple data set, indeed. 

 

The problem is that my actual dataset has thousands of "Countries" (I know there are not thousands of countries, but I changed the field names to share the dataset structure haha)

 

I was hoping to get a way to calculated with DAX measures so that I can then add Card visualizations with a slicer to select the Country I want to see or the class of store I want to see or both. 

 

Do you know any solution for this? 

Thanks a lot! 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

    It looks like [base] measure created by smpa01  can meet your needs. I didn't find any error in his measure. The card can be filtered properly. Please recheck it.

    ā€ƒ

     

     

    If I have misunderstood,  please explain your needs in more detail.

     

    Best Regards,
    Community Support Team _ Eason