Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Issue with Count

Hi,   I'm confused about the number of proposals.   I used the card then select count distinct even created a few dax using count and distinctcount but the numbers don't add up.   As shown the ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Anonymous , Check if there are some hidden rows are there or not in csv, and check count in Power Query while doing transformation

     

    TotalProposals = COUNT('Table'[ProposalID])
    UniqueProposals = DISTINCTCOUNT('Table'[ProposalID])

  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Anonymous - Can you cross check the proposal count in table view, what is the distinct count? ensure that your DAX measures are accurately counting distinct values based on the correct criteria.

    I hope there are no filters applied to the card visual or the page that might affect the count

     

    may be if there is any filters applied use the below measure

     

    DistinctProposalCount_NoFilters =
    CALCULATE(
    DISTINCTCOUNT('YourTable'[Proposal No]),
    REMOVEFILTERS('YourTable')
    )

     

     

    still issue exist, share some sampledata for reference.

    Hope it helps

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Anonymous - Can you cross check the proposal count in table view, what is the distinct count? ensure that your DAX measures are accurately counting distinct values based on the correct criteria.

I hope there are no filters applied to the card visual or the page that might affect the count

 

may be if there is any filters applied use the below measure

 

DistinctProposalCount_NoFilters =
CALCULATE(
DISTINCTCOUNT('YourTable'[Proposal No]),
REMOVEFILTERS('YourTable')
)

 

 

still issue exist, share some sampledata for reference.

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!