Forum Discussion
Bokazoit
Continued Contributor
Continued ContributorNeed 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: ...
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
BokazoitContinued Contributor
Continued ContributorHere 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 🙂
Payeras_BISolution Sage