Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have a Slicer that filters on Area, it works fine on my matrix, but when I put a Measure on my matrix I get the shops that my slicer is filtering and I also get all the other shops with the measure at 100%.
Why does my slicer not filter on the Measure?
Here is the code for the Measure.
Solved! Go to Solution.
Hi @GrahamR99 ,
It is caused by minus 1 while calculating increased percentage. Please try to drag the column "Shops" which is from the table "Shops" into the table.
Please see the attachment below.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I doubt join is missing between tables.
Hello amitchandak
What is a doubt join?
There is no relationship between the two tables as I have a thrid table which is a list of shops which has a relationship to both tables and blocks me from creating a relationship between the two tables.
The only line is a merge and that is a full outer join.
Regards
GrahamR99
Hi @GrahamR99 ,
It is caused by minus 1 while calculating increased percentage. Please try to drag the column "Shops" which is from the table "Shops" into the table.
Please see the attachment below.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Xue Ding
Thank you for your help the minus 1 pointed me in the right direction.
I was able to use a simlar formual as a column instead of a measure.
Regards
GrahamR99
Hello Xue Ding
When I delete the -1 from the measure formual the filter works.
What is the -1 doing to stop the filter from working?
However I need a matrix with sales this year, sales last year and the percentage differance. Now I have over 100% for my percentage difference.
Regards
GrahamR99
Hi @GrahamR99 ,
You could change the formula from a/b-1 to (a-b)/b like below.
Measure =
VAR a_minus_b =
SUM ( CT_Query[Total_Gross_Paid] )
- SUM ( CT_Query[CT_Query_LastYear.Total_Gross_Paid] )
RETURN
DIVIDE ( a_minus_b, SUM ( CT_Query[CT_Query_LastYear.Total_Gross_Paid] ) )
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |