Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Wrong Count Distinct result in Power BI

Hi,   I want to simply calculate the total number of PurchaseOrderId in Power BI Desktop as per my below example, but the result gives me a wrong count.   Here is the settings in the below table:...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous 

 

The following measure should work as long as you use the right fields.

PurchaseOrderId filed in the table visual should be the same as the one used in the measure ( comming from the same table ).

Measure = DISTINCTCOUNT( 'OrderedItemSummary'[PurchaseOrderId] )
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mariusz,

 

I already tried your solution but that still gave me a wrong result as before (see last column "Measure" in the below table.

Any other ways on how to solve this problem?

 

 

Best regards,

Emily

 

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

     

    Please check if you are not applying any filters ( page level or all pages ).
    If you are prepping data in Query Editor check if you have not left any filters there.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Mariusz,

       

      Yes I already checked the filters at visual/page level but none of them applied to the page & visuals that I am working with. Same for query editor with no pre-filters applied.

       

      Best regards,

      Emily

       

       

      • Mariusz's avatar
        Mariusz
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Hi Anonymous 

         

        Can you share the screenshot of your data model?

         

        Best Regards,
        Mariusz

        Please feel free to connect with me.
        Mariusz Repczynski