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
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 🙂

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

    Anonymous See the pbix file I have added now. Hope for a solution. If I hardcode the date in the measure it works also, but that is not a possible way - ofcourse