Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
1 year ago
Solved

Distinct count

Hi All ,    I'm looking to make a count of buildings which have been grouped in my database that are performing well based on energy usage last period compared to the current period.    Green Co...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JamesBurke,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.


    The issue with both Green Buildings and Not Green Count returning the same result likely stems from the filtering context and the way you're referencing the Date table in your DAX expressions. To resolve this,

    use the ALL('Date') function to remove slicers and filters on the Date table. Ensure proper relationships between the FactUWP and Date tables.


    If the issue still persists, please feel free to share more details with Sample data and expected output so that we can further investigate and help resolve it.

    If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

     

    Thank you & regards,
    Prasanna Kumar

     

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523