Forum Discussion

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

Divide Count ifs equivalent to dax

Hi all   How could I get a dax measure like the one below I did in excel?     Here is the table:   Topic Impact % ABC High 75.00% ABC High 75.00% ABC High 75.00% A...
Need Help
Show and Tell
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi, 

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

 

 

Expected result CC =
VAR _topic =
    COUNTROWS ( FILTER ( Data, Data[Topic] = EARLIER ( Data[Topic] ) ) )
VAR _impact =
    COUNTROWS (
        FILTER (
            Data,
            Data[Topic] = EARLIER ( Data[Topic] )
                && Data[Impact] = EARLIER ( Data[Impact] )
        )
    )
RETURN
    DIVIDE ( _impact, _topic )
  • o59393's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Hi Jihwan_Kim 

     

    I am getting this error highlighted in red:

     

    Any idea why?


    Thanks.

     

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

      Hi, 

      is this written for a measure or a calculated column?

      My sample solution is, as mentioned above, for calculated column.

      Thanks.

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

        Hi Jihwan_Kim 

         

        Should be a measure. 

         

        Thanks!