Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI

Measure 19 = IF(COUNTROWS(VALUES('AIPL 2(Line Scan)'[MN])) = 1, SUM('AIPL 2(Line Scan)'[MN]),SUMX(VALUES('AIPL 2(Line Scan)'[MN]), 'AIPL 2(Line Scan)'[MN])) The above formula does not work when the v...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data and show the expected result.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

Attaching here the Screenshot fyr.

Here if you see for B3 line, since the values are same for B3A & B3B line i.e 69, total is coming 69 only, ideally its should be 69+69=138.

Please help.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Share the download link of the PBI file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, the file is confidentail. Wont be able to share it. if you require any other details please let me know.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Anonymise the data in the file and share the download link.