Forum Discussion

IF's avatar
IF
Post Prodigy
3 years ago
Solved

Data in different rows

Hi, I am using a data source that is not really designed in a good way. I have slicers for the month, type, and name. Score 3 is calculated by Score1/Score2. For example; Name=A, Month=7.2022 should...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi IF ,

     

    I think the easiest fix is to also check the "#" in the slicer as shown in the image below:

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
3 years ago

IF , Create a measure like

 

Divide(Sum(Table[Score1]), Sum(Table[Score2]))

 

And in visual-only use name and month, do use type 

 

else try

 

calculate(Divide(Sum(Table[Score1]), Sum(Table[Score2])) , filter(Allselected(Table), Table[name] = max(Table[name])  && Table[Month] = max(Table[Month])  ) )

  • IF's avatar
    IF
    Post Prodigy
    3 years ago

    Hi,

    I tried both options but doesn't work. I want to highlight again that I am using "type" slicer and the data is not normal. Thanks