Forum Discussion
Helper ICalculation not working when slicers applied
Hi jmorela1 ,
You must add a new measure that is the cost per google for or whatever other name you want to give it and di the division of both the measures you refere:
Has you can see on my image the measure for the division between both of this values gives the correct value:
In the file I have shared search for the measure Cost per google form and use it on the matrix you should get the correct value.
Super UserHello jmorela1,
I examined your file and I have to say that BU and channel work fine, the point is that they show a single value so there is no difference between selecting that value or not (the only way this could make a difference, having one value, is when data are messy and you are missing a few keys, this is not the case). What I would sugges you is, on the above matter, to check whether you should have multiple vallues for those two columns while you have a single one and act accordingly.
I also checked briefly the data model and I strongly suggest you to consider whether to keep or not the many to many cardinality bi-directional filter, which is usually discouraged, unless it is the only option. Many-to-many cardinality is fine (even gout a one to many would be better but it might be this is impossible in your case), but the bidirectional thing really should be avoided.
If you need more support, please let us know, or if you want to explain the model thing so we can come back on the motivations you have, as a bad practice safe check
Best
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Helper IThis does not resolve the issue