Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

Sum string values for total in rows

Hi, I have this measure that counts my [document number]. CALCULATE(     DISTINCTCOUNT('Outbound Delivery Document'[DocumentNumber]),     REMOVEFILTERS('Date'[Date]),     TREATAS(VALUES('Outboun...
Need Help
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Justas4478 , Try using measure

 


TotalDistinctDocumentCount =
CALCULATE(
[DistinctDocumentCount],
ALL('Outbound Delivery Document')
)

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

bhanu_gautam I tried it but still got same results.

 

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    Can you share PBIX file

    • Justas4478's avatar
      Justas4478
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      bhanu_gautam I can't share the pbi file since I am on live connection model.