Forum Discussion

Macccc's avatar
Macccc
Frequent Visitor
7 years ago

numeric dstribution/detention

Hello Forum,

I am pretty new to Power BI and sometimes I even doubt if I should be using it...

I have aproblem I need to solve:

I need to find the % of brand presence in each store (Brand detention)

and the % of stores per each Brand (numeric distribution)

I have no idea how to calculate this.

Could you please Help?

Thanks in advance

 

 

 

 

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Macccc,

     

    You may add the following measure to a Matrix visual.

    Measure =
VAR c =
    HASONEFILTER ( Table1[Client] )
VAR b =
    HASONEFILTER ( Table1[Brand] )
RETURN
    SWITCH (
        TRUE (),
        AND ( c, b ), "P",
        AND ( c, NOT ( b ) ), DIVIDE ( DISTINCTCOUNT ( Table1[Brand] ), COUNTROWS ( ALL ( Table1[Brand] ) ) ),
        AND ( NOT ( c ), b ), DIVIDE (
            DISTINCTCOUNT ( Table1[Client] ),
            COUNTROWS ( ALL ( Table1[Client] ) )
        )
    )
    • Macccc's avatar
      Macccc
      Frequent Visitor
      7 years ago

      Thanks Sam for the fast reply;

      I applied your formula but it doesn't work - I get 100% presence when it is not true.

      What can be wrong? Is there a better way for me to explain the problem?

      Thanks in advance