Forum Discussion

thomasreick's avatar
thomasreick
Icon for Resolver I rankResolver I
2 years ago
Solved

Colouring measure not working properly

This is related to my last question   I want use a measure comparing against monthly figures. The number of months is coming from a slicer. The used measures are.... [# Contracts] = COUNTROWS(...
DAX help needed
Hints & Tips
  • thomasreick's avatar
    thomasreick
    2 years ago

    I have found the solution with a litle help frmo my friend ChatGPT....

    TotalAverage=

    VAR TotalSum = CALCULATE(SUM(facttable[countablevalue]), ALLSELECTED(calendar))
    VAR TotalPeriods = CALCULATE(DISTINCTCOUNT(calendar[YYYYMM]), ALLSELECTED(calendar))

    RETURN

        IF(

            TotalPeriods > 0,

            TotalSum / TotalPeriods ,

            BLANK()

        )

     

    I did not paid attention to filtercontext.

     

    Thank you very much for readng and input.

     

    Thomas

thomasreick's avatar
thomasreick
Icon for Resolver I rankResolver I
2 years ago

I have found the solution with a litle help frmo my friend ChatGPT....

TotalAverage=

VAR TotalSum = CALCULATE(SUM(facttable[countablevalue]), ALLSELECTED(calendar))
VAR TotalPeriods = CALCULATE(DISTINCTCOUNT(calendar[YYYYMM]), ALLSELECTED(calendar))

RETURN

    IF(

        TotalPeriods > 0,

        TotalSum / TotalPeriods ,

        BLANK()

    )

 

I did not paid attention to filtercontext.

 

Thank you very much for readng and input.

 

Thomas