Forum Discussion

haiquangitvn's avatar
haiquangitvn
Regular Visitor
5 years ago

A toggle checkbox on PowerBI

One of the requirement for my small PowerBI project is a toggle checkbox. For example, here is 'salesperson'  table     When the checkbox is checked, only 'KeyEmployee' will display on the d...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

TotalSales=CALCULATE(SUM(Sales[Sales Amount]),IF(SELECTEDVALUE(Checkbox[Id])=1,Salesperson[KeyEmployee]=1,TRUE()))