Forum Discussion

Juju123's avatar
Juju123
Icon for Helper III rankHelper III
2 years ago
Solved

CountRow return wrong result

Hi,  I have this table :    I create this measure in dax :      COUNTROWS(FILTER(VALUES('TABLE'[Référence]),[Difference_test]<>0))     The result I should have is 27 but Power BI gi...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Juju123 ,

    I tested using the pbix file you gave me.
    Because your data is so large, I created a slicer using the ‘Reference’ column and the ‘Annee’ column for display:

    You can use the following DAX to create a measure:

    Count Distinct Month = 
CALCULATE(
    DISTINCTCOUNT(Feuil6[Mois]),
    ALLSELECTED(Feuil6),
    'Feuil6'[Année] = SELECTEDVALUE(Feuil6[Année]),
    'Feuil6'[Référence] = SELECTEDVALUE(Feuil6[Référence])
)

    And the final output is shown in the following figure, as we mentioned earlier, 44030786AD:F8294-B673 appears in 8 months of 2023, so let's put this to the test:

     

    Best Regards,

    Dino Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.







Juju123's avatar
Juju123
Icon for Helper III rankHelper III
2 years ago

Hi Anonymous ,

Thanks you for answer but i try to change dax formula and i have an syntaxe error : 

The syntax for “)” is incorrect. (DAX(COUNTROWS(FILTER('TABLE'),[DIFFERENCE_TEST]<>0)))).

 

COUNTROWS(FILTER('TABLE'),[Difference_test]<>0))

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Juju123 Sorry I missed a backet after 'Table").  Please remove this.