Forum Discussion

maruthi's avatar
maruthi
Frequent Visitor
8 years ago
Solved

Data Modelling Challenge

Hi All,   I am trying to achieve a simple report in Power BI. I have attached a sample images for reference.   Fact_Table,Dim_Speaker data looks like below:  When I create a si...
Need Help
  • maruthi's avatar
    maruthi
    8 years ago

    Hi MarkS,

     As per your suggestion, I tried to unpivot data and updated dashboard. It's working now. Thanks for your suggestion.

    PietroFarias,I will try your solution and let you know. Thanks for your reply.

     

    Have a nice day!!!

PietroFarias's avatar
PietroFarias
Resolver II
8 years ago

Another way, can be done by DAX. Below is the DAX used to generate this table. And then a link to an Excel file with the result.

 

CountReach :=
SUMX (
    SUMMARIZE (
        Dim_Speaker;
        Dim_Speaker[SpeakerName];
        "Total"; SUMX (
            FILTER (
                Fact_Table;
                Fact_Table[Speaker1name] = Dim_Speaker[SpeakerName]
                    || Fact_Table[Speaker2name] = Dim_Speaker[SpeakerName]
                    || Fact_Table[Speaker3name] = Dim_Speaker[SpeakerName]
            );
            Fact_Table[Reach]
        )
    );[Total]
)

 

Donwload sample:

DAX PowerPivot - Excel