Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Due to Data sensitivity, i am representing the values as below.
Requirement:
I have two columns as below
Column1 | Column2 |
Apple | Blue |
Orange | Black |
Apple | Green |
Apple | Green |
Apple | Green |
Orange | Green |
Apple | Green |
Others | Black |
Orange | Blue |
Others | Blue |
Apple | Black |
Orange | Blue |
Others | Green |
Others | Blue |
Orange | Black |
Others | Green |
Orange | Green |
Others | Black |
Apple | Blue |
Apple | Black |
Here i am concerned with only three data point: two values from Column1 and one from Column2.
Apple | 8 |
Orange | 6 |
Green | 8 |
I have to bring up a Slicer which should show values of only "Apple,Orange and Green" and it need to project the same count as mentioned above.
But when i try to apply condtions involing two columns then i am getting unique values as per selection. for example, Apple and Orange are showing as expected but when i select Green then it shows as 2 (as other 6 values are part of Apple & Orange).
Regards
Santosh Kumar
Solved! Go to Solution.
Hi @SantoshKumar ,
Create a slicer table like below:
Then create a measure:
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Column1]=SELECTEDVALUE(Slicer[value])||'Table'[Column2]=SELECTEDVALUE(Slicer[value])))
Hi @SantoshKumar ,
Create a slicer table like below:
Then create a measure:
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Column1]=SELECTEDVALUE(Slicer[value])||'Table'[Column2]=SELECTEDVALUE(Slicer[value])))
@SantoshKumar , if you want that king of display, then you need to unpivot the table
https://radacad.com/pivot-and-unpivot-with-power-bi
Or create a table
distinct(union(distinct(Table[Column1]) ,Table[Column2]) ))
join with both the columns, one join will active and one will inactive ,
then use userelationship and use that measure to create
dim = count(Table1[Colum1]) _ calculate(count(Table1[column1], userelationship(dim[column1], table[column2]))
assume join with column two in inactive
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |