Forum Discussion
Dynamic Calculated Value Based on Two Slicers
Hi Anonymous ,
According to your description, I'm afraid it can't be achieved in a single table, as Power BI can't distinguash the same column in two seperate slicers. Here's my solution.
1.In Power Query, right-click the table and select Duplicate to create a duplicate table. The two tables should have not relationship in data model.
2.Create a measure.
Measure = DIVIDE ( COUNT ( 'Table (2)'[WORKERS] ), COUNT ( 'Table'[WORKERS] ) )3.Then put PROJECT columns from the two tables to seperate slicers, put WORKERS columns from two tables to seperate card visuals and select Count in the fileds pane, then put the measure in a card visual, get the result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your description, I'm afraid it can't be achieved in a single table, as Power BI can't distinguash the same column in two seperate slicers. Here's my solution.
1.In Power Query, right-click the table and select Duplicate to create a duplicate table. The two tables should have not relationship in data model.
2.Create a measure.
Measure =
DIVIDE ( COUNT ( 'Table (2)'[WORKERS] ), COUNT ( 'Table'[WORKERS] ) )
3.Then put PROJECT columns from the two tables to seperate slicers, put WORKERS columns from two tables to seperate card visuals and select Count in the fileds pane, then put the measure in a card visual, get the result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Although this solution works, my IRL problem I have to do this division with several tables and they're quite large. I don't know if duplicating all the tables will result in a file with double the size and half the 'speed'.
Thanks anyways 😉