Forum Discussion

xadya's avatar
xadya
Frequent Visitor
8 years ago
Solved

Calculating absolute percentage with interactions

Hey all,   I have a dataset with tweets of all over the world. One visualization I have includes a map of locations of Tweets:     I can select based on city and what I want to do is to ca...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    xadya,

    Please check if the DAX below returns your expected result. If not, please share sample data of your original table.

    Measure = CALCULATE(COUNT('finalSet1-100927'[Country]);ALLEXCEPT('finalSet1-100927';'finalSet1-100927'[Country])) / CALCULATE(COUNTROWS('finalSet1-100927'); 'finalSet1-100927'[Country] <> "NA";ALL('finalSet1-100927'))



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

xadya,

Please check if the DAX below returns your expected result. If not, please share sample data of your original table.

Measure = CALCULATE(COUNT('finalSet1-100927'[Country]);ALLEXCEPT('finalSet1-100927';'finalSet1-100927'[Country])) / CALCULATE(COUNTROWS('finalSet1-100927'); 'finalSet1-100927'[Country] <> "NA";ALL('finalSet1-100927'))



Regards,
Lydia

xadya's avatar
xadya
Frequent Visitor
8 years ago

Thanks a lot! I never thought about the ALLEXCEPT as a solution for this, but it makes sense!