Forum Discussion

aslan's avatar
aslan
Icon for Helper I rankHelper I
9 years ago

I didn't understand your solution. It looks correct but i don't know how use it.

 

Calculated column may work but I get value of 67.99 and 79.71 by (MeasureA-MeasureB)/MeasureA formula. So i don't know how can make a calculated column. MeasureA =SUM(Column1NUMBER) and MeasureB = DISTINCTCOUNT(Column2STRING) ( Also both of those columns are coming from different tables)

BTW; I use  Tabular as source and work Live on PowerBI.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Let me get this straight: 73,78% is the correct answer, but you are seeking for an incorrect answer.

 

That's why your measure results in 73.78%.

 

In order to get your incorrect answer of 73.85%, you need a calculated column with the percentages and then take the average of those percentages (excluding zeroes),

 

I know how to do the manipulation in Power Query to get the answer you are looking for, but not in DAX.

 

My advice would be to accept 73.78% as the correct answer.

 

 

  • aslan's avatar
    aslan
    Icon for Helper I rankHelper I
    9 years ago

    Hi MarcelBeug 73.78% is correct but client want to see 73.85% by calculating average. But couldn't create calculated column and because of that can't calculate average.

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      9 years ago

      This is what I did in Power Query:

       

      let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Value1", Int64.Type}, {"Value2", Int64.Type}}),
    #"Inserted Division" = Table.AddColumn(#"Changed Type", "Inserted Division", each [Value1] / [Value2], type number),
    #"Changed Type1" = Table.TransformColumnTypes(#"Inserted Division",{{"Inserted Division", Percentage.Type}})
in
    #"Changed Type1"
      • aslan's avatar
        aslan
        Icon for Helper I rankHelper I
        9 years ago

        MarcelBeugthere can be a way to use same logic with dax also but i am not well with dax because of that couldn't convert it to dax. But anyway thanks for your all help.