Forum Discussion

Bokazoit's avatar
Bokazoit
Icon for Continued Contributor rankContinued Contributor
4 years ago

Need help with measure

This measure is created using a detached Date dimension - as can be seen from this data model:     Doing that makes it possible to calculate the correct distinct count, using this DAX:   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Bokazoit ,

How about modifying this measure?

Antal verserende sager test = 

VAR MinDato = MINX(ALL(DimDato),DimDato[DatoKey])

RETURN

CALCULATE(
    DISTINCTCOUNT(FactArvesager[ArvesagsKey]),
    FactArvesager[Forventet afsluttet Dato] >= MinDato && 
    FactArvesager[Bostarts Dato] < MinDato &&
    (FactArvesager[Realiseretarv Dato] = BLANK() || FactArvesager[Realiseretarv Dato] >= MinDato),
    USERELATIONSHIP(FactArvesager[Forventet afsluttet Dato],DimDato[DatoKey])
)

 

If it does not help, how about creating relationships like the Filterdato?

 

If I have misundstood your meaning, please provide your desired output and your  pbix file without privacy information.

How to Get Your Question Answered Quickly 

 

Best Regards

Community Support Team _ Polly

 

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

  • Bokazoit's avatar
    Bokazoit
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    Does not help at al 😞

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Bokazoit ,

      If I have misundstood your meaning, please provide your desired output and your  pbix file without privacy information.

      How to Get Your Question Answered Quickly 

       

      Best Regards

      Community Support Team _ Polly

       

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

      • Bokazoit's avatar
        Bokazoit
        Icon for Continued Contributor rankContinued Contributor
        4 years ago

        Here is a sample file:

         

        https://drive.google.com/file/d/1yjp20i4tZP0GAnSbSe-06f4TtkQowIrh/view?usp=sharing 

        There is two sheets, and the results in each sheet is correct, but for the result in the sheet 'Forecast' to be correct, I need to create a new date dimension as described above. I would like to use just the Primary date dimension.

         

        Hope this gives You what You need.

         

        Thx in advance 🙂