Forum Discussion

uranus's avatar
uranus
Regular Visitor
1 year ago

Matrix Table interaction to Table Visual

Hi Guys,   Need help, new in power bi here, I have a matrix table that contains the number of overdue items and their risk ratings. The idea is if i click on the 2 items listed under account 2 with...
Need Help
Tips and Tricks
suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi uranus 

 

Try with this measure 

Count_Major_Overdue =
CALCULATE(
    COUNTROWS(TableName),
    TableName[RiskRating] = "Major",
    TableName[Status] = "Overdue"
)

 

Let me know if it works.