Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to make a presentation on power bi. I am stuck at a point where one of my rows mentions priority 1,2,3 and 4 and they all correspond with a specific country.
My question is that how to I get the total/count, of say priority 3 while corresponding with united kingdom? Bear in mind, the priority column and country column is different.
Thanks in advance!
Solved! Go to Solution.
It sounds like you need to use two slicers, one for country column and one for priority column.
Hi devilkak,
Would you please share some data example here?
If the purpose here is to get the total or the count value of Priority 3 of special country, then we could create two Slicers as smoupre suggested, if the country and the Priority are on the same table.
Otherwise, we should manage table relationship to make the Slicer workable.
If you would like to have a calculated measure to only show the total (or count) value, then we need to do some DAX calculation, which would the data sample to generate the correct DAX expression.
Regards
Hi devilkak,
Would you please share some data example here?
If the purpose here is to get the total or the count value of Priority 3 of special country, then we could create two Slicers as smoupre suggested, if the country and the Priority are on the same table.
Otherwise, we should manage table relationship to make the Slicer workable.
If you would like to have a calculated measure to only show the total (or count) value, then we need to do some DAX calculation, which would the data sample to generate the correct DAX expression.
Regards
It sounds like you need to use two slicers, one for country column and one for priority column.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |