Forum Discussion

NJ13's avatar
NJ13
Icon for Helper I rankHelper I
4 years ago
Solved

Calculated Measure not being filtered in my interactive dashboard

Hello All,

    i have a question in regards to measure filtering, i created new measures and added a pie or donut to my visualization but when i click on my visualization nothing is being filtered.... i edited interactions and filtered to all but still nothing, i also looked at my data model their is a relationship connected... can you please let me know what else I can do in order for my measured calculation to be able to filter and be interactive on my dashboard?

 

Formula i used for my measure

Recent YES Answer = CALCULATE (
COUNTROWS ( 'Data' ),
GENERATE (
VALUES ( 'Data'[code] ),
LASTDATE ( 'Data'[Date] )
),
'Data[question] = "Yes"
)

 

thank you 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi NJ13 ,

    I created a simple pbix file(see attachment) base on your provided info, the visual can be filtered correctly by the selected values. Whether you select no impact icon for the dotnut or pie chart just as the table visual on the below screenshot? If yes, the dotnut or pie chart will not be affected by the slicer options...

    Change how visuals interact in a Power BI report

    In order to make troubleshooting and provide you a suitable solution, could you please share some sample data, table relationship info and visual settings etc. info(exclude sensitive data) with us? Thank you.

    Best Regards

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    I think you need to  give more information, what are you filtering exactly?  what is your expected results and can you share your data, the model itself?  as in relationships etc.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NJ13 ,

    I created a simple pbix file(see attachment) base on your provided info, the visual can be filtered correctly by the selected values. Whether you select no impact icon for the dotnut or pie chart just as the table visual on the below screenshot? If yes, the dotnut or pie chart will not be affected by the slicer options...

    Change how visuals interact in a Power BI report

    In order to make troubleshooting and provide you a suitable solution, could you please share some sample data, table relationship info and visual settings etc. info(exclude sensitive data) with us? Thank you.

    Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NJ13 ,

    Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

    Best Regards