Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone im new in powerbi and Dax funtions
I trying to merge or sum all contents in multiple columns the divide from total of participants all the participants has multiple answers
Like the next image in excel using count.if and counta funtions
y try with the next messure:
Solved! Go to Solution.
@Anonymous
You can unpivot the table in Power Query and the rest is easy. Please find attached the Power BI file below my signatire.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , first of all, you might want to try transforming the dataset into a flat table,
then, you can author different measures to conduct different analyses.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
I try to upload my pbi file but i cant, unpivot my columns makes me error with other graphs and messure, let you below in the image and the data i use, and ty again everyone.
@Anonymous , first of all, you might want to try transforming the dataset into a flat table,
then, you can author different measures to conduct different analyses.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
I try to un pivot column but change my other messures can you check my replay pliz
@Anonymous
You can unpivot the table in Power Query and the rest is easy. Please find attached the Power BI file below my signatire.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Works! ty but change my other messures and change my other data analysis, can you check my replay! pliz