Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Apply total value not to every coloumn

Hey guys,   do you know maybe if it is possible to decide on what coloumn to apply the total value? I have 3 measures (they have to stay measure, cannot change to coloumn because they are linked to...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Anonymous

     

    Something like this ?

    BU Status =
IF (
    ISFILTERED ( 'Incident Report'[Bus Unit] );   
        UNICHAR (
        IF (
            'Incident Report'[Measure2 as Text] = "0";
            10003;
            IF (
                'Incident Report'[Measure2 as Text] = "2";
                10007;
                IF ( 'Incident Report'[Measure2 as Text] = "1"; 33 )
            )
        )
    )
)

    where we're only adding the IF with the check  (in red) to what you already had.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hey AlB,

 

thank you for your fast reply. 

 

could you please help me, where to put it? I have a measure, that is actually converting a measure into Unichar:

 

BU Status = UNICHAR(IF('Incident Report'[Measure2 as Text]="0";10003;IF('Incident Report'[Measure2 as Text]="2";10007;IF('Incident Report'[Measure2 as Text]="1";33))))
 
Measure2 as Text = FORMAT( CALCULATE(MAX('Incident Report'[ASPStatusID]);ALLEXCEPT('ServiceDashboard'; 'ServiceDashboard'[Bus Unit]);
FILTER('Incident Report';(CALCULATE(MIN('Incident Report'[Incident Start Date]))>=CALCULATE(MIN('CALENDAR'[Date])) && CALCULATE(MAX('Incident Report'[Incident Start Date]))<=CALCULATE(MAX('CALENDAR'[Date])+1)||CALCULATE(MIN('Incident Report'[Incident End Date]))>=CALCULATE(MIN('CALENDAR'[Date])) && CALCULATE(MAX('Incident Report'[Incident End Date]))<=CALCULATE(MAX('CALENDAR'[Date])+1)))
)+0;"")
 
Thank you in advance!
 
Many thanks,
 
Adam
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

Something like this ?

BU Status =
IF (
    ISFILTERED ( 'Incident Report'[Bus Unit] );   
    UNICHAR (
        IF (
            'Incident Report'[Measure2 as Text] = "0";
            10003;
            IF (
                'Incident Report'[Measure2 as Text] = "2";
                10007;
                IF ( 'Incident Report'[Measure2 as Text] = "1"; 33 )
            )
        )
    )
)

where we're only adding the IF with the check  (in red) to what you already had.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey AlB,

     

    I checked and it's unfortunately not working. :/ However, for the ISFILTERED I put ServiceDashboard[Bus Unit], as it's only present in that database.

     

    Maybe some other idea? :) I would greatly appreciate!

     

    Many thanks,

     

    Adam

     

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous

       

      What's happening exactly? What is not working?

      Can you share the pbix? We'd be faster like that

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hey AlB,

         

        sorry, I just had to re-create the table, afterwards it worked! Many thanks for it!

         

        Do you know maybe, how it is possible to add a measure as a filter? - a workaround maybe?

         

        The "Current Service Status" Measure is linked to the slicer, and changing based on the time.

         

        The "Current Service Status Static" Coloumn is also linked to slicer, however not changing based on the time.

         

        I would like to have however a chart, where I have an overview of the service statuses, within the chosen time horizon (Measure as Filter).

         

        Any help would be greatly appreciated, here is the link for the pbtx. https://1drv.ms/u/s!Ah2VGOQRBzRVhijIn6jmykLe5DBS

         

        Many thanks,

         

        Adam