There are two types of measures in Microsoft Power BI models: implicit and explicit. Implicit measures are automatic and summarize column data in visuals.
Explicit measures, also referred to as just measures, are custom calculations you create for your model. Put simply, implicit measures are columns that can be aggregated automatically, while explicit measures are custom calculations defined using DAX, and is THE measure that we are familiar of.
Continue reading
Need to connect Tableau to a dataset or semantic model in PowerBI(now Fabric)?It is not as difficult as you may think.
Continue reading
In Power BI, you often has to decide whether to create a column or measure to achieve your analytic goals, though they can be used inter-changeablely in a many cases, they are very different in how they function and perform.
Continue reading
It happens sometimes that the report metrics usage report suddenly stopped refreshing, you waited 24 hours as suggested and click on that refresh button hundreds of times and still no new data, then you tried to check the semantic model, it gives this sad message.
Continue reading
If/esleif/else is one of the the most used functions in Tableau calculation and unfortunately, it can not be applied verbatim in Power BI to achieve the same goal. The equivalent function in Power BI DAX language is the Switch() function and it works especially well on multiple scenarios, it can be used to convert either if/elseif/else statement of possibly case/when query in Tableau.
Continue reading