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.

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi IF ,

 

OK, please create a measure:

 

New_score3 = IF(ISINSCOPE('Table'[Name]),MAX('Table'[score3]),SUM('Table'[Score2]) &"/"& SUM('Table'[Score1]))

 

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.

IF's avatar
IF
Post Prodigy
3 years ago

I really appreciate for your help and time. This time date and name is working but the "type" slicer is not bringing the result. regards,

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    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.