The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have a measure calculating the Rolling sum of last three months and it is giving me the correct result. But when i am trying to filter the sum using a column from the same table from where the measure is calculated the result is not filtering. Below screen shot will help you understand better
Am i missing any logic here?
Any suggestion are welcome
Solved! Go to Solution.
Check if your interactions are on. See edit interaction. if that is not the issue then
maybe because of the context in which the measure is being calculated. In Power BI, the "CALCULATE" function changes the context in which data is analyzed, and it sounds like you're using it in your measure.
suggestion add filter to your calculation. then field you are using in your slicer, filter it. for example
ALL(Table[Date]), VALUES(Table[slicer clumn name])
you need to adjust your measure with correct names and syntax.
Proud to be a Super User!
Check if your interactions are on. See edit interaction. if that is not the issue then
maybe because of the context in which the measure is being calculated. In Power BI, the "CALCULATE" function changes the context in which data is analyzed, and it sounds like you're using it in your measure.
suggestion add filter to your calculation. then field you are using in your slicer, filter it. for example
ALL(Table[Date]), VALUES(Table[slicer clumn name])
you need to adjust your measure with correct names and syntax.
Proud to be a Super User!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523