Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Help to add and count different values in parallel

Hello everyone
I need your wisdom and advice. I have the following table that indicates the number of accidents and the total rest days that each of these accidents has. In turn, the Sabbath days are broken down month by month as shown in the following image:

ivanmay_0-1634694232188.png


Here what is complicating me, I need to create a report with two visualizers (card), one that tells me the accidents and another that I add the rest days that are imputed in that month.
How can I create a filter that allows me to do both? I can count the claims with the accident date filters on the one hand and on the other I can add the rest days of the month by performing UNPIVOT in the table ... but I can't do both operations at the same time with a single filter.
I don't know if you understand, any suggestions?
Thanks a lot!

  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Syndicate_Admin ,

     

    Can you convert the content in the screenshot to English so I can easily understand your needs.
    I did the following test to create two measures that show different results depending on the filtered values in the slicer. The reference is as follows:

    M_1 = 
var sel_ = SELECTEDVALUE('Table'[Date])
return
CALCULATE(MAX('Table'[Name]),'Table'[Date]=sel_)
    M_2 = 
var sel_ = SELECTEDVALUE('Table'[Date])
return
CALCULATE(MAX('Table'[Value]),'Table'[Date]=sel_)

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Syndicate_Admin ,

     

    Can you convert the content in the screenshot to English so I can easily understand your needs.
    I did the following test to create two measures that show different results depending on the filtered values in the slicer. The reference is as follows:

    M_1 = 
var sel_ = SELECTEDVALUE('Table'[Date])
return
CALCULATE(MAX('Table'[Name]),'Table'[Date]=sel_)
    M_2 = 
var sel_ = SELECTEDVALUE('Table'[Date])
return
CALCULATE(MAX('Table'[Value]),'Table'[Date]=sel_)

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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